APPS.WSMPWROT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 224: select 'x' from wip_requirement_operations r

220: where
221: o1.wip_entity_id = p_wip_entity_id
222: and o1.operation_sequence_id = o.operation_sequence_id
223: and not exists (
224: select 'x' from wip_requirement_operations r
225: where
226: r.wip_entity_id = p_wip_entity_id
227: and r.organization_id = p_organization_id
228: and ((r.OPERATION_SEQ_NUM = o1.operation_seq_num) or

Line 857: INSERT INTO WIP_REQUIREMENT_OPERATIONS

853: END LOOP;
854:
855: l_stmt_num := 120;
856:
857: INSERT INTO WIP_REQUIREMENT_OPERATIONS
858: (
859: inventory_item_id,
860: organization_id,
861: wip_entity_id,

Line 1017: WIP_REQUIREMENT_OPERATIONS WRO,

1013: BOM_OPERATION_RESOURCES BOR,
1014: BOM_DEPARTMENT_RESOURCES BDR1,
1015: BOM_OPERATION_SEQUENCES BOS,
1016: BOM_OPERATIONAL_ROUTINGS BRTG,
1017: WIP_REQUIREMENT_OPERATIONS WRO,
1018: MTL_SYSTEM_ITEMS MSI --BUG 7598223
1019: WHERE
1020: BRTG.organization_id = p_organization_id
1021: and BRTG.assembly_item_id = wro.inventory_item_id

Line 1199: --delete from wip_requirement_operations where wip_entity_id=p_wip_entity_id and operation_seq_num<0;

1195: WSMPWROT.EXPLOSION_GROUP_ID := NULL;
1196:
1197: --End NL BugFix 2786476
1198:
1199: --delete from wip_requirement_operations where wip_entity_id=p_wip_entity_id and operation_seq_num<0;
1200:
1201: EXCEPTION
1202:
1203: WHEN be_exploder_exception THEN