ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729751A9E05362FB09050512Y select rq.Job, rq.Job_Desc, rq.Status, rq.C_ASSY, rq.Assembly_ID, rq.Assembly_Desc, rq.Planner, rq.Scheduled_Start, rq.Class, rq.Class_Desc, rq.Job_Start_Qty, rq.Scheduled_Complete, rq.Supply_Code, rq.Wip_Supply_Type, rq.Date_Required, rq.Component, rq.Comp_Desc, rq.Op_Seq, rq.Supply_Subinv, rq.Supply_Locator, rq.Locator_Id, rq.Quantity_Open, rq.UOM, rq.On_Hand_Subinv, rq.On_Hand_Locator, rq.Supply_Flag, rq.Quantity_On_Hand, rq.Build_Sequence, rq.Schedule_Group_Name, rq.Item_Seq, rq.C_ASSY_DISP, rq.C_Order, rq.C_Comp_Sort, rq.C_Loc_Sort, rq.C_Component_Disp, rq.C_Locator_Disp, rq.C_Det_Loc_Disp, rq.Scheduled_Start1, rq.Scheduled_complete1, rq.DATE_REQUIRED1 FROM (SELECT DECODE(:P_SORT_BY, 9, 'X',WE.WIP_ENTITY_NAME) Job , DECODE(:P_SORT_BY, 9, 'X',WE.DESCRIPTION ) Job_Desc , DECODE(:P_SORT_BY, 9, 'X',ML1.MEANING ) Status , DECODE(:P_SORT_BY, 9, 'X',null ) C_ASSY , DECODE(:P_SORT_BY, 9, -1,NVL(WDJ.PRIMARY_ITEM_ID, -1)) Assembly_ID , DECODE(:P_SORT_BY, 9, 'X',MSITL.DESCRIPTION ) Assembly_Desc , DECODE(:P_SORT_BY, 9, 'X',MSI.PLANNER_CODE) Planner , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_START_DATE) Scheduled_Start , DECODE(:P_SORT_BY, 9, 'X',WDJ.CLASS_CODE ) Class , DECODE(:P_SORT_BY, 9, 'X',WAC.DESCRIPTION) Class_Desc , DECODE(:P_SORT_BY, 9, 0,WDJ.START_QUANTITY) Job_Start_Qty , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_COMPLETION_DATE) Scheduled_Complete , DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) Supply_Code , ML2.MEANING Wip_Supply_Type , DECODE(:P_SORT_BY, 9, SYSDATE,WRO.DATE_REQUIRED ) Date_Required , null Component , MSI2.DESCRIPTION Comp_Desc , DECODE(:P_SORT_BY, 9, 0,WRO.OPERATION_SEQ_NUM ) Op_Seq , WRO.SUPPLY_SUBINVENTORY Supply_Subinv , null Supply_Locator , NVL(MIL.INVENTORY_LOCATION_ID,-1) Locator_Id , SUM(WRO.REQUIRED_QUANTITY - WRO.QUANTITY_ISSUED) Quantity_Open , MSI2.PRIMARY_UOM_CODE UOM , MOQ2.SUBINVENTORY_CODE On_Hand_Subinv , DECODE(MIL2.INVENTORY_LOCATION_ID,NULL,NULL,&P_DETAIL_LOC) On_Hand_Locator , DECODE(MOQ2.SUBINVENTORY_CODE,NVL(WRO.SUPPLY_SUBINVENTORY,'-1'), DECODE(NVL(MOQ2.LOCATOR_ID,-1),NVL(WRO.SUPPLY_LOCATOR_ID,-1),1,0),0) Supply_Flag , NVL(MOQ2.QUANTITY,0) Quantity_On_Hand , DECODE(:P_SORT_BY, 9,0, WDJ.BUILD_SEQUENCE) Build_Sequence , DECODE(:P_SORT_BY, 9, 'X',SG.SCHEDULE_GROUP_NAME) Schedule_Group_Name , DECODE(:P_SORT_BY, 9, 0, BIC.ITEM_NUM) Item_Seq, decode(WDJ.PRIMARY_ITEM_ID,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assy_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_ASSY_DISP, WIP_WIPDJPCK_XMLP_PKG.order_func(( MSI2.SEGMENT1 || '\n' || MSI2.SEGMENT2 || '\n' || MSI2.SEGMENT3 || '\n' || MSI2.SEGMENT4 || '\n' || MSI2.SEGMENT5 || '\n' || MSI2.SEGMENT6 || '\n' || MSI2.SEGMENT7 || '\n' || MSI2.SEGMENT8 || '\n' || MSI2.SEGMENT9 || '\n' || MSI2.SEGMENT10 || '\n' || MSI2.SEGMENT11 || '\n' || MSI2.SEGMENT12 || '\n' || MSI2.SEGMENT13 || '\n' || MSI2.SEGMENT14 || '\n' || MSI2.SEGMENT15 || '\n' || MSI2.SEGMENT16 || '\n' || MSI2.SEGMENT17 || '\n' || MSI2.SEGMENT18 || '\n' || MSI2.SEGMENT19 || '\n' || MSI2.SEGMENT20 ), ( MIL.SEGMENT1 || '\n' || MIL.SEGMENT2 || '\n' || MIL.SEGMENT3 || '\n' || MIL.SEGMENT4 || '\n' || MIL.SEGMENT5 || '\n' || MIL.SEGMENT6 || '\n' || MIL.SEGMENT7 || '\n' || MIL.SEGMENT8 || '\n' || MIL.SEGMENT9 || '\n' || MIL.SEGMENT10 || '\n' || MIL.SEGMENT11 || '\n' || MIL.SEGMENT12 || '\n' || MIL.SEGMENT13 || '\n' || MIL.SEGMENT14 || '\n' || MIL.SEGMENT15 || '\n' || MIL.SEGMENT16 || '\n' || MIL.SEGMENT17 || '\n' || MIL.SEGMENT18 || '\n' || MIL.SEGMENT19 || '\n' || MIL.SEGMENT20 ), :C_Component_Disp, :C_Locator_Disp, :C_Comp_Sort, :C_Loc_Sort, WRO.SUPPLY_SUBINVENTORY, DECODE ( :P_SORT_BY , 9 , 0 , WRO.OPERATION_SEQ_NUM ), DECODE ( :P_SORT_BY , 9 , SYSDATE , WRO.DATE_REQUIRED ), DECODE ( :P_SORT_BY , 9 , 0 , BIC.ITEM_NUM )) C_Order, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_Comp_Sort, WIP_WIPDJPCK_XMLP_PKG.c_loc_sortformula(:C_Locator_Disp, NVL ( MIL.INVENTORY_LOCATION_ID , - 1 ), :C_Loc_Sort) C_Loc_Sort, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_Component_Disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_Locator_Disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_det_loc_disp', 'INV', 'MTLL', 101, MIL2.ORGANIZATION_ID, MIL2.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_Det_Loc_Disp, DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_START_DATE,'DD-MON-YY')) Scheduled_Start1 ,DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_COMPLETION_DATE,'DD-MON-YY')) Scheduled_complete1 , DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WRO.DATE_REQUIRED,'DD-MON-YY')) DATE_REQUIRED1 FROM MFG_LOOKUPS ML1 , MFG_LOOKUPS ML2 , MTL_ITEM_LOCATIONS MIL , MTL_ITEM_LOCATIONS MIL2 , MTL_SECONDARY_INVENTORIES MSINV , MTL_ITEM_QUANTITIES_VIEW MOQ2 , WIP_ENTITIES WE , MTL_SYSTEM_ITEMS_B MSI , MTL_SYSTEM_ITEMS_TL MSITL , WIP_ACCOUNTING_CLASSES WAC , MTL_SYSTEM_ITEMS_VL MSI2 , WIP_REQUIREMENT_OPERATIONS WRO , WIP_SCHEDULE_GROUPS SG , WIP_DISCRETE_JOBS WDJ , BOM_INVENTORY_COMPONENTS BIC WHERE WDJ.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WDJ.STATUS_TYPE IN &C_Limit_Status AND SG.SCHEDULE_GROUP_ID &P_SG_OUTER = WDJ.SCHEDULE_GROUP_ID AND SG.ORGANIZATION_ID &P_SG_OUTER = WDJ.ORGANIZATION_ID AND ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND ML1.LOOKUP_CODE = WDJ.STATUS_TYPE AND ML1.ENABLED_FLAG = 'Y' AND MSI.INVENTORY_ITEM_ID(+) = WDJ.PRIMARY_ITEM_ID AND MSI.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSITL.INVENTORY_ITEM_ID(+) = WDJ.PRIMARY_ITEM_ID AND MSITL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSITL.LANGUAGE(+) = USERENV('LANG') AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND WE.ENTITY_TYPE IN (1,6) AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Jobs &C_Limit_Dates &C_Schedule_Group AND WAC.CLASS_CODE = WDJ.CLASS_CODE AND WAC.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND WRO.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WRO.WIP_SUPPLY_TYPE <> 6 AND ( ( WRO.REQUIRED_QUANTITY > 0 AND WRO.REQUIRED_QUANTITY - WRO.QUANTITY_ISSUED > 0 ) OR ( WRO.REQUIRED_QUANTITY < 0 AND WRO.REQUIRED_QUANTITY - WRO.QUANTITY_ISSUED < 0 ) ) &C_Limit_Supply_Type &C_Limit_Subinv AND ML2.LOOKUP_TYPE = 'WIP_SUPPLY_PICK' AND ML2.LOOKUP_CODE = DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) AND ML2.ENABLED_FLAG = 'Y' AND MIL.INVENTORY_LOCATION_ID(+) = WRO.SUPPLY_LOCATOR_ID AND MIL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSI2.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID AND MSI2.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND MOQ2.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MOQ2.INVENTORY_ITEM_ID(+) = WRO.INVENTORY_ITEM_ID AND MSINV.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSINV.SECONDARY_INVENTORY_NAME(+) = MOQ2.SUBINVENTORY_CODE AND MSINV.DISABLE_DATE(+) IS NULL AND MIL2.INVENTORY_LOCATION_ID(+) = MOQ2.LOCATOR_ID AND MIL2.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND BIC.COMPONENT_SEQUENCE_ID(+) = WRO.COMPONENT_SEQUENCE_ID AND NOT(NVL(MSI2.RECEIVING_ROUTING_ID,-1) = 3 AND MSI2.STOCK_ENABLED_FLAG = 'N' AND WE.ENTITY_TYPE <> 1 ) GROUP BY DECODE(:P_SORT_BY, 9, 'X',WE.WIP_ENTITY_NAME) , DECODE(:P_SORT_BY, 9, 'X',WE.DESCRIPTION ) , DECODE(:P_SORT_BY, 9, 'X',ML1.MEANING ) , DECODE(:P_SORT_BY, 9, 'X',null) , DECODE(:P_SORT_BY, 9, -1,NVL(WDJ.PRIMARY_ITEM_ID, -1)) , DECODE(:P_SORT_BY, 9, 'X',MSITL.DESCRIPTION ) , DECODE(:P_SORT_BY, 9, 'X',MSI.PLANNER_CODE) , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_START_DATE) , DECODE(:P_SORT_BY, 9, 'X',WDJ.CLASS_CODE ) , DECODE(:P_SORT_BY, 9, 'X',WAC.DESCRIPTION) , DECODE(:P_SORT_BY, 9, 0,WDJ.START_QUANTITY) , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_COMPLETION_DATE) , DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) , ML2.MEANING , DECODE(:P_SORT_BY, 9, SYSDATE,WRO.DATE_REQUIRED ) , null , MSI2.DESCRIPTION , DECODE(:P_SORT_BY,9,0,WRO.OPERATION_SEQ_NUM ) , DECODE(:P_SORT_BY,9,0,BIC.ITEM_NUM) , WRO.SUPPLY_SUBINVENTORY , null , NVL(MIL.INVENTORY_LOCATION_ID,-1) , MSI2.PRIMARY_UOM_CODE , MOQ2.SUBINVENTORY_CODE , DECODE(MIL2.INVENTORY_LOCATION_ID,NULL,NULL,&P_DETAIL_LOC) , MOQ2.REVISION , DECODE(MOQ2.SUBINVENTORY_CODE,NVL(WRO.SUPPLY_SUBINVENTORY,'-1') , DECODE(NVL(MOQ2.LOCATOR_ID,-1),NVL(WRO.SUPPLY_LOCATOR_ID,-1),1,0),0) , NVL(MOQ2.QUANTITY,0) , DECODE(:P_SORT_BY, 9,0, WDJ.BUILD_SEQUENCE) , DECODE(:P_SORT_BY, 9, 'X',SG.SCHEDULE_GROUP_NAME), decode(WDJ.PRIMARY_ITEM_ID,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assy_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_det_loc_disp', 'INV', 'MTLL', 101, MIL2.ORGANIZATION_ID, MIL2.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), ( MSI2.SEGMENT1 || '\n' || MSI2.SEGMENT2 || '\n' || MSI2.SEGMENT3 || '\n' || MSI2.SEGMENT4 || '\n' || MSI2.SEGMENT5 || '\n' || MSI2.SEGMENT6 || '\n' || MSI2.SEGMENT7 || '\n' || MSI2.SEGMENT8 || '\n' || MSI2.SEGMENT9 || '\n' || MSI2.SEGMENT10 || '\n' || MSI2.SEGMENT11 || '\n' || MSI2.SEGMENT12 || '\n' || MSI2.SEGMENT13 || '\n' || MSI2.SEGMENT14 || '\n' || MSI2.SEGMENT15 || '\n' || MSI2.SEGMENT16 || '\n' || MSI2.SEGMENT17 || '\n' || MSI2.SEGMENT18 || '\n' || MSI2.SEGMENT19 || '\n' || MSI2.SEGMENT20 ), ( MIL.SEGMENT1 || '\n' || MIL.SEGMENT2 || '\n' || MIL.SEGMENT3 || '\n' || MIL.SEGMENT4 || '\n' || MIL.SEGMENT5 || '\n' || MIL.SEGMENT6 || '\n' || MIL.SEGMENT7 || '\n' || MIL.SEGMENT8 || '\n' || MIL.SEGMENT9 || '\n' || MIL.SEGMENT10 || '\n' || MIL.SEGMENT11 || '\n' || MIL.SEGMENT12 || '\n' || MIL.SEGMENT13 || '\n' || MIL.SEGMENT14 || '\n' || MIL.SEGMENT15 || '\n' || MIL.SEGMENT16 || '\n' || MIL.SEGMENT17 || '\n' || MIL.SEGMENT18 || '\n' || MIL.SEGMENT19 || '\n' || MIL.SEGMENT20 ), DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_START_DATE,'DD-MON-YY')) ,DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_COMPLETION_DATE,'DD-MON-YY')) ,DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WRO.DATE_REQUIRED,'DD-MON-YY')) UNION SELECT DECODE(:P_SORT_BY, 9, 'X',WE.WIP_ENTITY_NAME) Job , DECODE(:P_SORT_BY, 9, 'X',WE.DESCRIPTION ) Job_Desc , DECODE(:P_SORT_BY, 9, 'X',ML1.MEANING ) Status , DECODE(:P_SORT_BY, 9, 'X',null ) C_ASSY , DECODE(:P_SORT_BY, 9, -1,NVL(WDJ.PRIMARY_ITEM_ID, -1)) Assembly_ID , DECODE(:P_SORT_BY, 9, 'X',MSITL.DESCRIPTION ) Assembly_Desc , DECODE(:P_SORT_BY, 9, 'X',MSI.PLANNER_CODE) Planner , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_START_DATE) Scheduled_Start , DECODE(:P_SORT_BY, 9, 'X',WDJ.CLASS_CODE ) Class , DECODE(:P_SORT_BY, 9, 'X',WAC.DESCRIPTION) Class_Desc , DECODE(:P_SORT_BY, 9, 0,WDJ.START_QUANTITY) Job_Start_Qty , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_COMPLETION_DATE) Scheduled_Complete , DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) Supply_Code , ML2.MEANING Wip_Supply_Type , DECODE(:P_SORT_BY, 9, SYSDATE,WRO.DATE_REQUIRED ) Date_Required , null Component , MSI2.DESCRIPTION Comp_Desc , DECODE(:P_SORT_BY, 9, 0,WRO.OPERATION_SEQ_NUM ) Op_Seq , WRO.SUPPLY_SUBINVENTORY Supply_Subinv , null Supply_Locator , NVL(MIL.INVENTORY_LOCATION_ID,-1) Locator_Id , SUM(WRO.REQUIRED_QUANTITY - WRO.QUANTITY_ISSUED) Quantity_Open , MSI2.PRIMARY_UOM_CODE UOM , MOQ2.SUBINVENTORY_CODE On_Hand_Subinv , DECODE(MIL2.INVENTORY_LOCATION_ID,NULL,NULL,&P_DETAIL_LOC) On_Hand_Locator , DECODE(MOQ2.SUBINVENTORY_CODE,NVL(WRO.SUPPLY_SUBINVENTORY,'-1'), DECODE(NVL(MOQ2.LOCATOR_ID,-1),NVL(WRO.SUPPLY_LOCATOR_ID,-1),1,0),0) Supply_Flag , NVL(MOQ2.QUANTITY,0) Quantity_On_Hand , DECODE(:P_SORT_BY, 9,0, WDJ.BUILD_SEQUENCE) Build_Sequence , DECODE(:P_SORT_BY, 9, 'X',SG.SCHEDULE_GROUP_NAME) Schedule_Group_Name , DECODE(:P_SORT_BY, 9, 0, BIC.ITEM_NUM) Item_Seq, decode(WDJ.PRIMARY_ITEM_ID,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assy_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_ASSY_DISP, WIP_WIPDJPCK_XMLP_PKG.order_func(( MSI2.SEGMENT1 || '\n' || MSI2.SEGMENT2 || '\n' || MSI2.SEGMENT3 || '\n' || MSI2.SEGMENT4 || '\n' || MSI2.SEGMENT5 || '\n' || MSI2.SEGMENT6 || '\n' || MSI2.SEGMENT7 || '\n' || MSI2.SEGMENT8 || '\n' || MSI2.SEGMENT9 || '\n' || MSI2.SEGMENT10 || '\n' || MSI2.SEGMENT11 || '\n' || MSI2.SEGMENT12 || '\n' || MSI2.SEGMENT13 || '\n' || MSI2.SEGMENT14 || '\n' || MSI2.SEGMENT15 || '\n' || MSI2.SEGMENT16 || '\n' || MSI2.SEGMENT17 || '\n' || MSI2.SEGMENT18 || '\n' || MSI2.SEGMENT19 || '\n' || MSI2.SEGMENT20 ), ( MIL.SEGMENT1 || '\n' || MIL.SEGMENT2 || '\n' || MIL.SEGMENT3 || '\n' || MIL.SEGMENT4 || '\n' || MIL.SEGMENT5 || '\n' || MIL.SEGMENT6 || '\n' || MIL.SEGMENT7 || '\n' || MIL.SEGMENT8 || '\n' || MIL.SEGMENT9 || '\n' || MIL.SEGMENT10 || '\n' || MIL.SEGMENT11 || '\n' || MIL.SEGMENT12 || '\n' || MIL.SEGMENT13 || '\n' || MIL.SEGMENT14 || '\n' || MIL.SEGMENT15 || '\n' || MIL.SEGMENT16 || '\n' || MIL.SEGMENT17 || '\n' || MIL.SEGMENT18 || '\n' || MIL.SEGMENT19 || '\n' || MIL.SEGMENT20 ), :C_Component_Disp, :C_Locator_Disp, :C_Comp_Sort, :C_Loc_Sort, WRO.SUPPLY_SUBINVENTORY, DECODE ( :P_SORT_BY , 9 , 0 , WRO.OPERATION_SEQ_NUM ), DECODE ( :P_SORT_BY , 9 , SYSDATE , WRO.DATE_REQUIRED ), DECODE ( :P_SORT_BY , 9 , 0 , BIC.ITEM_NUM )) C_Order, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_Comp_Sort, WIP_WIPDJPCK_XMLP_PKG.c_loc_sortformula(:C_Locator_Disp, NVL ( MIL.INVENTORY_LOCATION_ID , - 1 ), :C_Loc_Sort) C_Loc_Sort, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_Component_Disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_Locator_Disp, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_det_loc_disp', 'INV', 'MTLL', 101, MIL2.ORGANIZATION_ID, MIL2.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_Det_Loc_Disp, DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_START_DATE,'DD-MON-YY')) Scheduled_Start1 ,DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_COMPLETION_DATE,'DD-MON-YY')) Scheduled_complete1 , DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WRO.DATE_REQUIRED,'DD-MON-YY')) DATE_REQUIRED1 FROM MFG_LOOKUPS ML1 , MFG_LOOKUPS ML2 , MTL_ITEM_LOCATIONS MIL , MTL_ITEM_LOCATIONS MIL2 , MTL_SECONDARY_INVENTORIES MSINV , MTL_ITEM_QUANTITIES_VIEW MOQ2 , WIP_ENTITIES WE , MTL_SYSTEM_ITEMS_B MSI , MTL_SYSTEM_ITEMS_TL MSITL , WIP_ACCOUNTING_CLASSES WAC , MTL_SYSTEM_ITEMS_VL MSI2 , WIP_REQUIREMENT_OPERATIONS WRO , WIP_SCHEDULE_GROUPS SG , WIP_DISCRETE_JOBS WDJ , BOM_INVENTORY_COMPONENTS BIC WHERE WDJ.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WDJ.STATUS_TYPE IN &C_Limit_Status AND SG.SCHEDULE_GROUP_ID &P_SG_OUTER = WDJ.SCHEDULE_GROUP_ID AND SG.ORGANIZATION_ID &P_SG_OUTER = WDJ.ORGANIZATION_ID AND ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND ML1.LOOKUP_CODE = WDJ.STATUS_TYPE AND ML1.ENABLED_FLAG = 'Y' AND MSI.INVENTORY_ITEM_ID(+) = WDJ.PRIMARY_ITEM_ID AND MSI.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSITL.INVENTORY_ITEM_ID(+) = WDJ.PRIMARY_ITEM_ID AND MSITL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSITL.LANGUAGE(+) = USERENV('LANG') AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND WE.ENTITY_TYPE IN (1,6) AND WE.ORGANIZATION_ID = :P_ORGANIZATION_ID &C_Limit_Jobs &C_Limit_Dates &C_Schedule_Group AND WAC.CLASS_CODE = WDJ.CLASS_CODE AND WAC.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND WRO.ORGANIZATION_ID = :P_ORGANIZATION_ID AND WRO.WIP_SUPPLY_TYPE <> 6 AND ( ( WRO.REQUIRED_QUANTITY > 0 AND WRO.REQUIRED_QUANTITY - WRO.QUANTITY_ISSUED > 0 ) OR ( WRO.REQUIRED_QUANTITY < 0 AND WRO.REQUIRED_QUANTITY - WRO.QUANTITY_ISSUED < 0 ) ) &C_Limit_Supply_Type &C_Limit_Subinv AND ML2.LOOKUP_TYPE = 'WIP_SUPPLY_PICK' AND ML2.LOOKUP_CODE = DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) AND ML2.ENABLED_FLAG = 'Y' AND MIL.INVENTORY_LOCATION_ID(+) = WRO.SUPPLY_LOCATOR_ID AND MIL.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSI2.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID AND MSI2.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND MOQ2.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MOQ2.INVENTORY_ITEM_ID(+) = WRO.INVENTORY_ITEM_ID AND MSINV.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND MSINV.SECONDARY_INVENTORY_NAME(+) = MOQ2.SUBINVENTORY_CODE AND MSINV.DISABLE_DATE(+) > TRUNC(SYSDATE) AND MIL2.INVENTORY_LOCATION_ID(+) = MOQ2.LOCATOR_ID AND MIL2.ORGANIZATION_ID(+) = :P_ORGANIZATION_ID AND BIC.COMPONENT_SEQUENCE_ID(+) = WRO.COMPONENT_SEQUENCE_ID AND NOT(NVL(MSI2.RECEIVING_ROUTING_ID,-1) = 3 AND MSI2.STOCK_ENABLED_FLAG = 'N' AND WE.ENTITY_TYPE <> 1 ) GROUP BY DECODE(:P_SORT_BY, 9, 'X',WE.WIP_ENTITY_NAME) , DECODE(:P_SORT_BY, 9, 'X',WE.DESCRIPTION ) , DECODE(:P_SORT_BY, 9, 'X',ML1.MEANING ) , DECODE(:P_SORT_BY, 9, 'X',null) , DECODE(:P_SORT_BY, 9, -1,NVL(WDJ.PRIMARY_ITEM_ID, -1)) , DECODE(:P_SORT_BY, 9, 'X',MSITL.DESCRIPTION ) , DECODE(:P_SORT_BY, 9, 'X',MSI.PLANNER_CODE) , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_START_DATE) , DECODE(:P_SORT_BY, 9, 'X',WDJ.CLASS_CODE ) , DECODE(:P_SORT_BY, 9, 'X',WAC.DESCRIPTION) , DECODE(:P_SORT_BY, 9, 0,WDJ.START_QUANTITY) , DECODE(:P_SORT_BY, 9, SYSDATE,WDJ.SCHEDULED_COMPLETION_DATE) , DECODE(WRO.WIP_SUPPLY_TYPE,2,2,3,2,WRO.WIP_SUPPLY_TYPE) , ML2.MEANING , DECODE(:P_SORT_BY, 9, SYSDATE,WRO.DATE_REQUIRED ) , null , MSI2.DESCRIPTION , DECODE(:P_SORT_BY,9,0,WRO.OPERATION_SEQ_NUM ) , DECODE(:P_SORT_BY,9,0,BIC.ITEM_NUM) , WRO.SUPPLY_SUBINVENTORY , null , NVL(MIL.INVENTORY_LOCATION_ID,-1) , MSI2.PRIMARY_UOM_CODE , MOQ2.SUBINVENTORY_CODE , DECODE(MIL2.INVENTORY_LOCATION_ID,NULL,NULL,&P_DETAIL_LOC) , MOQ2.REVISION , DECODE(MOQ2.SUBINVENTORY_CODE,NVL(WRO.SUPPLY_SUBINVENTORY,'-1') , DECODE(NVL(MOQ2.LOCATOR_ID,-1),NVL(WRO.SUPPLY_LOCATOR_ID,-1),1,0),0) , NVL(MOQ2.QUANTITY,0) , DECODE(:P_SORT_BY, 9,0, WDJ.BUILD_SEQUENCE) , DECODE(:P_SORT_BY, 9, 'X',SG.SCHEDULE_GROUP_NAME), decode(WDJ.PRIMARY_ITEM_ID,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_assy_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_comp_sort', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_component_disp', 'INV', 'MSTK', 101, MSI2.ORGANIZATION_ID, MSI2.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_locator_disp', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('c_det_loc_disp', 'INV', 'MTLL', 101, MIL2.ORGANIZATION_ID, MIL2.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), ( MSI2.SEGMENT1 || '\n' || MSI2.SEGMENT2 || '\n' || MSI2.SEGMENT3 || '\n' || MSI2.SEGMENT4 || '\n' || MSI2.SEGMENT5 || '\n' || MSI2.SEGMENT6 || '\n' || MSI2.SEGMENT7 || '\n' || MSI2.SEGMENT8 || '\n' || MSI2.SEGMENT9 || '\n' || MSI2.SEGMENT10 || '\n' || MSI2.SEGMENT11 || '\n' || MSI2.SEGMENT12 || '\n' || MSI2.SEGMENT13 || '\n' || MSI2.SEGMENT14 || '\n' || MSI2.SEGMENT15 || '\n' || MSI2.SEGMENT16 || '\n' || MSI2.SEGMENT17 || '\n' || MSI2.SEGMENT18 || '\n' || MSI2.SEGMENT19 || '\n' || MSI2.SEGMENT20 ), ( MIL.SEGMENT1 || '\n' || MIL.SEGMENT2 || '\n' || MIL.SEGMENT3 || '\n' || MIL.SEGMENT4 || '\n' || MIL.SEGMENT5 || '\n' || MIL.SEGMENT6 || '\n' || MIL.SEGMENT7 || '\n' || MIL.SEGMENT8 || '\n' || MIL.SEGMENT9 || '\n' || MIL.SEGMENT10 || '\n' || MIL.SEGMENT11 || '\n' || MIL.SEGMENT12 || '\n' || MIL.SEGMENT13 || '\n' || MIL.SEGMENT14 || '\n' || MIL.SEGMENT15 || '\n' || MIL.SEGMENT16 || '\n' || MIL.SEGMENT17 || '\n' || MIL.SEGMENT18 || '\n' || MIL.SEGMENT19 || '\n' || MIL.SEGMENT20 ), DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_START_DATE,'DD-MON-YY')) ,DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WDJ.SCHEDULED_COMPLETION_DATE,'DD-MON-YY')) ,DECODE(:P_SORT_BY, 9,to_char(SYSDATE,'DD-MON-YY'),to_char(WRO.DATE_REQUIRED,'DD-MON-YY'))) rq ORDER BY JOB ASC,C_ASSY_DISP ASC,Scheduled_Start ASC,Planner ASC,Class ASC,Build_Sequence ASC,Schedule_Group_Name ASC,Supply_Code ASC,C_COMPONENT_DISP ASC,On_Hand_Subinv ASC,C_Det_Loc_Disp ASC,SUPPLY_FLAG ASC WIP WIPDJPCK_XML AR WIP تقرير قائمة انتقاء أوامر الشغل المنفصلة (بتنسيق XML) Imported from BI Publisher Description: تقرير قائمة لقط أمر الشغل المنفصل Application: العمل في الإنجاز Source: تقرير قائمة انتقاء أوامر الشغل المنفصلة (بتنسيق XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG D WIP Diskrete Aufträge - Entnahmeschein Imported from BI Publisher Description: Diskrete Aufträge - Entnahmeschein Application: Fertigung Source: Diskrete Aufträge - Entnahmeschein (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG E WIP Lista de Acopio de Órdenes de Fabricación Discretas Imported from BI Publisher Description: Informe de lista de acopio de órdenes de fabricación discretas Application: Work in Process Source: Lista de Acopio de Órdenes de Fabricación Discretas (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG F WIP Etat Liste à servir par OF Imported from BI Publisher Description: Etat Liste à servir par OF Application: Work In Process Source: Etat Liste à servir par OF (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG I WIP Rapporto Distinta di prelievo OdL discreti Imported from BI Publisher Description: Rapporto Distinta di prelievo OdL discreti Application: Work in Process Source: Rapporto Distinta di prelievo OdL discreti (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG JA WIP ショップ型製造オーダー・ピック・リスト・レポート Imported from BI Publisher Description: ショップ型製造オーダー・ピック・リスト・レポート Application: Work in Process Source: ショップ型製造オーダー・ピック・リスト・レポート(XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG KO WIP 단속 작업 불출 목록 보고서 Imported from BI Publisher Description: 단속 작업 출하목록 보고서 Application: Work in Process Source: 단속 작업 불출 목록 보고서(XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG PTB WIP Relatório Lista de Separação de OPs Discretas Imported from BI Publisher Description: Relatório de Ordens de Produção Discretas Application: Work in Process Source: Relatório Lista de Separação de OPs Discretas (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG RU WIP Список выбора для отдельных заданий Imported from BI Publisher Description: Список выбора для отдельных заданий Application: Незавершенное производство Source: Список выбора для отдельных заданий (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG S WIP Plocklista för diskret TO - rapport Imported from BI Publisher Description: Plocklista för diskret TO - rapport Application: Work in Process Source: Plocklista för diskret TO - rapport (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG TR WIP Kesikli İş Emri Toplama Listesi Raporu Imported from BI Publisher Description: Kesikli İş Emri Toplama Listesi Raporu Application: Üretim İzleme Source: Kesikli İş Emri Toplama Listesi Raporu (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG US WIP Discrete Job Pick List Imported from BI Publisher Description: Discrete Job Pick List Report Application: Work in Process Source: Discrete Job Pick List Report (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG ZHS WIP 离散任务拣料单报表 Imported from BI Publisher Description: 离散任务拣料单报表 Application: 在制品管理系统 Source: 离散任务拣料单报表 (XML) Short Name: WIPDJPCK_XML DB package: WIP_WIPDJPCK_XMLP_PKG BI Publisher &c_limit_dates &c_limit_jobs &c_limit_status &c_limit_subinv &c_limit_supply_type &c_schedule_group &p_detail_loc &p_sg_outer :c_comp_sort :c_component_disp :c_loc_sort :c_locator_disp :item_id_flex_num :p_assy :p_comp :p_conc_request_id :p_debug :p_detail_loc :p_from_date :p_from_job :p_organization_id :p_qty_precision :p_schedule_group_from :p_schedule_group_to :p_sg_outer :p_sort_by :p_supply_loc :p_supply_subinv :p_supply_type :p_to_date :p_to_job :p_txn_only :qty_precision 1 -30 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Org_Id معرف التنظيم D Org_Id Organisationskennung E Org_Id Id Organización F Org_Id ID organisation I Org_Id Id dell'organizzazione JA Org_Id 組織ID KO Org_Id 조직 ID PTB Org_Id Id da Organização RU Org_Id Идент. организ. S Org_Id Organisations-id TR Org_Id Organizasyon No US Org_Id Organization Id ZHS Org_Id 组织标识 2 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad precisión de cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점이하 자리수 수량 소수점자리 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision kvantitetsprecision TR Miktar Duyarlılığı miktar duyarlılığı US Quantity Precision quantity precision ZHS 数量精确度 数量精确度 3 10 :p_sort_by LOV Oracle WIP_SRS_DISC_PICK_SORT_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_REP_SRW_SORT' and lookup_code in (4,5,6,9,15) order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'WIP_REP_SRW_SORT' AND LOOKUP_CODE = 6 Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por clasificar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por classificar por RU Сортировка параметр сортировки S Sortera efter sortera efter TR Sıralama Ölçütü sıralama bazı US Sort By sort by ZHS 排序依据 排序依据 4 20 :p_txn_only LOV Oracle WIP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'SYS_YES_NO' AND LOOKUP_CODE = 2 Y AR قابل للحركة فقط قابل للحركة فقط D Nur transaktionsfähig Nur transaktionsfähig E Sólo Transacciones Permitidas sólo transacciones permitidas F Mouvement admis seulement Mouvement admis seulement I Solo transazione consentita Solo transazione consentita JA 取引可能のみ 取引可能のみ KO 트랜잭션 가능만 트랜잭션 가능만 PTB Somente Transacionável somente transacionável RU Только допускающие транзакции только допускающие транзакции S Endast överföringsbar endast överföringsbar TR Salt İşlemlenebilir salt işlemlenebilir US Transactable Only transactable only ZHS 仅可进行事务处理 仅可进行事务处理 5 30 :p_from_job LOV Oracle WIP_SRS_DISCRETE_JOBS_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type not in (2,9,10) order by wip_entity_name AR أوامر الشغل من أوامر شغل من D Von Fertigungsauftrag Von Fertigungsauftrag E De Orden de Fabricación de orden de fabricación F Ordres de fabrication - De OF - De I OdL - Da OdL - Da JA 製造オーダー:自 製造オーダー:自 KO 작업: 부터 작업: 부터 PTB Ordens de Produção - De Produções - De RU Задания с Задания с S Från TO TO från TR İş Emirleri, İlk iş emirleri: ilk US Jobs From jobs from ZHS 任务自 任务自 6 40 :p_to_job LOV Oracle WIP_SRS_DISCRETE_JOBS_OPT Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type not in (2,9,10) order by wip_entity_name AR إلى أوامر شغل إلي D Bis Bis Fertigungsauftrag E A a orden de fabricación F A OF - A I A OdL - A JA 至 製造オーダー:至 KO 까지 작업: 까지 PTB Até Ordens de Produção - até RU По задания по S Till TO till TR Son iş emirleri: son US To jobs to ZHS 至 任务至 7 50 :p_from_date Date AR تواريخ البداية من تواريخ البدايات من D Von Von E De Fecha de Inicio de fecha de inicio F Dates début - Du Dates de début - Du I Date inizio - Da Date inizio - Da JA 開始日:自 開始日:自 KO 시작 일자: 부터 시작일자: 부터 PTB Datas Iniciais - De Datas Iniciais - De RU Начальные даты с начальные даты с S Från startdatum startar datum från TR Başlangıç Tarihleri, İlk başlangıç tarihleri: ilk US Start Dates From starts dates from ZHS 起始日期自 起始日期自 8 60 :p_to_date Date AR إلى 2 التواريخ إلى D Bis 2 Bis E A 2 a fecha F A 2 Dates - Au I A 2 Date - A JA 至 2 日付:至 KO 까지 2 일자: 까지 PTB Até 2 Datas - De RU По 2 даты по S Till 2 datum till TR Son 2 Başlangıç Tarihi US To 2 dates to ZHS 至 2 终止日期 9 70 :p_schedule_group_from LOV Oracle WIP_SRS_SCHEDULE_GROUPS Y select wsg.schedule_group_name id, wsg.schedule_group_name value, null description from wip_schedule_groups wsg where wsg.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_group_name AR مجموعة الجدول من مدى مجموعة الجدول من D Von Planungsgruppe Von Planungsgruppe E De Grupo de Programas De Rango de Grupo de Programas F Groupe de planification - De Fourchette de groupes de planification - De I Gruppo di programmi da Intervallo del gruppo di programmi - Da JA 計画グループ 自 計画グループ範囲:自 KO 스케줄 그룹: 부터 스케줄 그룹 범위: 부터 PTB Grupo de Programações - De Faixa do Grupo de Programações - De RU Группа планирования с Нижняя граница диапазона групп планирования S Från schemagrupp Från schemagruppsintervall TR İlk Çizelge Grubu Çizelge Grup Aralığı Başlangıcı US Schedule Group From Schedule Group Range From ZHS 计划组自 计划组范围自 10 80 :p_schedule_group_to LOV Oracle WIP_SRS_SCHEDULE_GROUPS Y select wsg.schedule_group_name id, wsg.schedule_group_name value, null description from wip_schedule_groups wsg where wsg.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by schedule_group_name AR مجموعة الجداول إلى مدى مجموعة الجدول إلى D Bis Planungsgruppe Bis Planungsgruppe E A Grupo de Programas A Rango de Grupo de Programas F Groupe de planification - A Fourchette de groupes de planification - A I Gruppo di programmi a Intervallo gruppi di programmi - A JA 計画グループ 至 計画グループ範囲:至 KO 스케줄 그룹: 까지 스케줄 그룹 범위: 까지 PTB Grupo de Programações - Até Faixa do Grupo de Programações - Até RU Группа планирования по Верхняя граница диапазона групп планирования S Till schemagrupp Till schemagruppsintervall TR Son Çizelge Grubu Çizelge Grup Aralığı Bitişi US Schedule Group To Schedule Group Range To ZHS 计划组至 计划组范围至 11 90 :p_supply_type LOV Oracle WIP_SRS_SUPPLY_TYPES_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_SUPPLY_PICK' and lookup_code not in (6,7) order by lookup_code AR نوع التوريد نوع التوريد D Bedarfsdeckungsart Entnahmeart E Tipo de Aprovisionamiento tipo de aprovisionamiento F Type d'approvisionnement Type approvisionnement I Tipo di fornitura Tipo di fornitura JA 供給タイプ 供給タイプ KO 공급 유형 공급 유형 PTB Tipo de Suprimento Tipo de Suprimento RU Тип предложения Тип предложения S Tillgångstyp tillgångstyp TR Tedarik Tipi tedarik tipi US Supply Type supply type ZHS 供应类型 供应类型 12 100 :p_supply_subinv LOV Oracle WIP_SRS_SUBINVENTORIES_OPT Y select secondary_inventory_name id, secondary_inventory_name value, null description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and (disable_date is null or disable_date>trunc(sysdate)) order by secondary_inventory_name AR مخزن التوريد مخزن التوريد D Entnahmelager Entnahmelager E Subalmacén de Aprovisionamiento Subalmacén de aprovisionamiento F Magasin d'approvisionnement Magasin d'approvisionnement I Sottomagazzino di fornitura Sottomagazzino di fornitura JA 供給保管場所 供給保管場所 KO 공급 창고 공급 창고 PTB Subinventário de Suprimento Subinventário de Suprimento RU Складское подразделение предложения складское подразделение предложения S Lagerställe för uttag lagerställe för uttag TR Tedarik Stok Yeri tedarik stok yeri US Supply Subinventory supply subinventory ZHS 供应子库存 供应子库存