WIP Parameters

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: WIP Parameters Report (XML)
Short Name: WIPSUPMT_XML
DB package: WIP_WIPSUPMT_XMLP_PKG
select M.meaning,
                   M1.meaning meaning1,
                   M2.meaning meaning2,
                   M3.meaning meaning3,
                   M4.meaning meaning4,
                   M5.meaning meaning5,
                   P.default_pull_supply_subinv,
                   P.default_pull_supply_locator_id,
                   P.default_discrete_class,
                   fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator', 'INV', 'MTLL', 101, L.ORGANIZATION_ID, L.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXDATA,
                   P.autorelease_days,
                   P.OSP_SHOP_FLOOR_STATUS,
                   decode(P.COMPLETION_COST_SOURCE,
                   '','',
                M6.meaning) meaning6,
                   decode(P.COST_TYPE_ID,
                   '','',
                    M7.meaning) meaning7,
                   decode(P.AUTO_COMPUTE_FINAL_COMPLETION,
                   '','',
                    M8.meaning) meaning8,
                P.OSP_SHOP_FLOOR_STATUS OSP_SHOP_FLOOR_STATUS,
                   decode(P.MOVES_OVER_NO_MOVE_STATUSES,
                   '','',
                    M9.meaning) meaning9,
                P.Organization_ID,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator', 'INV', 'MTLL', 101, L.ORGANIZATION_ID, L.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_LOCATOR
            from wip_parameters P,
                 mfg_lookups M,
                 mfg_lookups M1,
                 mfg_lookups M2,
                 mfg_lookups M3,
                 mfg_lookups M4,
                 mfg_lookups M5,
                 mfg_lookups M6,
                 mfg_lookups M7,
                 mfg_lookups M8,
                 mfg_lookups M9,
                 mtl_item_locations L
            where P.organization_id = :P_Organization_Id
              and M.lookup_code = P.lot_number_default_type
              and M.lookup_type = 'WIP_LOT_NUMBER_DEFAULT'
              and M1.lookup_code = P.backflush_lot_entry_type
              and M1.lookup_type = 'WIP_BACKFLUSH_LOT_ENTRY'
              and M2.lookup_code = P.dynamic_operation_insert_flag
              and M2.lookup_type = 'SYS_YES_NO'
              and M3.lookup_code = P.mandatory_scrap_flag
              and M3.lookup_type = 'SYS_YES_NO'
              and M4.lookup_code = P.so_change_response_type
              and M4.lookup_type = 'WIP_SO_CHANGE_TYPE'
              and M5.lookup_code = P.repetitive_variance_type
              and M5.lookup_type = 'WIP_REPETITIVE_VARIANCE_TYPE'
              and M6.lookup_code = nvl(P.COMPLETION_COST_SOURCE,1)
              and M6.lookup_type = 'CST_COMPLETION_COST_SRC'
              and M7.lookup_code = nvl(P.COST_TYPE_ID,1)
              and M7.lookup_type = 'MTL_PRIMARY_COST'
              and M8.lookup_code = nvl(P.AUTO_COMPUTE_FINAL_COMPLETION, 1)
              and M8.lookup_type = 'SYS_YES_NO'
              and M9.lookup_code = nvl(P.MOVES_OVER_NO_MOVE_STATUSES, 1)
              and M9.lookup_type = 'SYS_YES_NO'
              and L.organization_id (+) = :P_Organization_Id
              and L.inventory_location_id (+) = P.default_pull_supply_locator_id
              and L.subinventory_code (+) = P.default_pull_supply_subinv
             and P.Organization_ID=:Organization_Id2
Parameter Name SQL text Validation
Org_Id
 
Number