DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 273: FROM wip_requirement_operations

269:
270:
271: CURSOR c_check_reqmt_ops( cp_wip_entity_id po_distributions_all.wip_entity_id%TYPE , cp_wip_op_seq_num po_distributions_all.wip_operation_seq_num%TYPE) IS
272: SELECT count(1)
273: FROM wip_requirement_operations
274: WHERE wip_entity_id = cp_wip_entity_id
275: AND operation_seq_num = cp_wip_op_seq_num
276: AND wip_supply_type <> 6;
277:

Line 497: FROM wip_requirement_operations wro

493:
494: For c_component_rec in
495: ( SELECT required_quantity ,quantity_per_assembly,inventory_item_id ,
496: component_sequence_id , 'W' item_type, comments
497: FROM wip_requirement_operations wro
498: WHERE wro.wip_entity_id = c_po_dist.wip_entity_id
499: AND wro.operation_seq_num = c_po_dist.wip_operation_seq_num
500: AND wip_supply_type <> 6
501: UNION