[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,' ');
2259: ||' UOM_CODE,'
2260: ||' BASIS_TYPE,'
2261: ||' ACTIVITY_ID,'
2262: ||' AUTOCHARGE_TYPE,'
2263: ||' STANDARD_RATE_FLAG,'
2264: ||' START_DATE,'
2265: ||' COMPLETION_DATE,'
2266: ||' INVENTORY_ITEM_ID_OLD,'
2267: ||' INVENTORY_ITEM_ID_NEW,'
2286: ||' PROGRAM_ID,'
2287: ||' PROGRAM_UPDATE_DATE,'
2288: ||' PARENT_HEADER_ID,'
2289: ||' DESCRIPTION,'
2290: ||' STANDARD_OPERATION_ID,'
2291: ||' FIRST_UNIT_START_DATE,'
2292: ||' FIRST_UNIT_COMPLETION_DATE,'
2293: ||' LAST_UNIT_START_DATE,'
2294: ||' LAST_UNIT_COMPLETION_DATE,'
2335: ||' UOM_CODE,'
2336: ||' BASIS_TYPE,'
2337: ||' ACTIVITY_ID,'
2338: ||' AUTOCHARGE_TYPE,'
2339: ||' STANDARD_RATE_FLAG,'
2340: ||' START_DATE,'
2341: ||' COMPLETION_DATE,'
2342: ||' INVENTORY_ITEM_ID_OLD,'
2343: ||' INVENTORY_ITEM_ID_NEW,'
2362: ||' PROGRAM_ID,'
2363: ||' PROGRAM_UPDATE_DATE,'
2364: ||' PARENT_HEADER_ID,'
2365: ||' DESCRIPTION,'
2366: ||' STANDARD_OPERATION_ID,'
2367: ||' FIRST_UNIT_START_DATE,'
2368: ||' FIRST_UNIT_COMPLETION_DATE,'
2369: ||' LAST_UNIT_START_DATE,'
2370: ||' LAST_UNIT_COMPLETION_DATE,'
3462: lv_wip_entity_id
3463: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3464: wip_job_schedule_interface jsi
3465: WHERE jsi.group_id = G_WIP_GROUP_ID
3466: AND jsi.load_type in(1,3) /* create standard job */
3467: AND rtng.assembly_item_id(+)= jsi.primary_item_id
3468: AND rtng.organization_id(+)= jsi.organization_id
3469: AND NVL(rtng.alternate_routing_designator(+),' ')=
3470: NVL( jsi.alternate_routing_designator,' ');
3565:
3566:
3567: BEGIN
3568:
3569: SELECT os.operation_seq_num,os.standard_operation_id
3570: BULK COLLECT
3571: INTO luno_op_seq_num,luno_std_op_Seq_id
3572: FROM BOM_OPERATION_SEQUENCES os
3573: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3977: created_by,
3978: group_id,
3979: parent_header_id,
3980: operation_seq_num,
3981: standard_operation_id,
3982: organization_id,
3983: substitution_type,
3984: load_type,
3985: first_unit_start_date,