[Home] [Help]
271: lv_wip_entity_id
272: FROM BOM_OPERATIONAL_ROUTINGS rtng,
273: WSM_LOT_JOB_INTERFACE jsi
274: WHERE jsi.group_id = G_WIP_GROUP_ID
275: AND jsi.load_type in (5,6) /* standard job */
276: AND rtng.assembly_item_id(+)= jsi.primary_item_id
277: AND rtng.organization_id(+)= jsi.organization_id
278: AND NVL(rtng.alternate_routing_designator(+),' ')=
279: NVL( jsi.alternate_routing_designator,' ');
2258: ||' UOM_CODE,'
2259: ||' BASIS_TYPE,'
2260: ||' ACTIVITY_ID,'
2261: ||' AUTOCHARGE_TYPE,'
2262: ||' STANDARD_RATE_FLAG,'
2263: ||' START_DATE,'
2264: ||' COMPLETION_DATE,'
2265: ||' INVENTORY_ITEM_ID_OLD,'
2266: ||' INVENTORY_ITEM_ID_NEW,'
2285: ||' PROGRAM_ID,'
2286: ||' PROGRAM_UPDATE_DATE,'
2287: ||' PARENT_HEADER_ID,'
2288: ||' DESCRIPTION,'
2289: ||' STANDARD_OPERATION_ID,'
2290: ||' FIRST_UNIT_START_DATE,'
2291: ||' FIRST_UNIT_COMPLETION_DATE,'
2292: ||' LAST_UNIT_START_DATE,'
2293: ||' LAST_UNIT_COMPLETION_DATE,'
2334: ||' UOM_CODE,'
2335: ||' BASIS_TYPE,'
2336: ||' ACTIVITY_ID,'
2337: ||' AUTOCHARGE_TYPE,'
2338: ||' STANDARD_RATE_FLAG,'
2339: ||' START_DATE,'
2340: ||' COMPLETION_DATE,'
2341: ||' INVENTORY_ITEM_ID_OLD,'
2342: ||' INVENTORY_ITEM_ID_NEW,'
2361: ||' PROGRAM_ID,'
2362: ||' PROGRAM_UPDATE_DATE,'
2363: ||' PARENT_HEADER_ID,'
2364: ||' DESCRIPTION,'
2365: ||' STANDARD_OPERATION_ID,'
2366: ||' FIRST_UNIT_START_DATE,'
2367: ||' FIRST_UNIT_COMPLETION_DATE,'
2368: ||' LAST_UNIT_START_DATE,'
2369: ||' LAST_UNIT_COMPLETION_DATE,'
3175: lv_wip_entity_id
3176: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3177: wip_job_schedule_interface jsi
3178: WHERE jsi.group_id = G_WIP_GROUP_ID
3179: AND jsi.load_type in(1,3) /* create standard job */
3180: AND rtng.assembly_item_id(+)= jsi.primary_item_id
3181: AND rtng.organization_id(+)= jsi.organization_id
3182: AND NVL(rtng.alternate_routing_designator(+),' ')=
3183: NVL( jsi.alternate_routing_designator,' ');
3278:
3279:
3280: BEGIN
3281:
3282: SELECT os.operation_seq_num,os.standard_operation_id
3283: BULK COLLECT
3284: INTO luno_op_seq_num,luno_std_op_Seq_id
3285: FROM BOM_OPERATION_SEQUENCES os
3286: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3688: created_by,
3689: group_id,
3690: parent_header_id,
3691: operation_seq_num,
3692: standard_operation_id,
3693: organization_id,
3694: substitution_type,
3695: load_type,
3696: first_unit_start_date,