DBA Data[Home] [Help]

APPS.JAI_PO_OSP_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 333: FROM wip_requirement_operations

329: AND operation_seq_num < cp_wip_operation ;
330:
331: 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
332: SELECT count(1)
333: FROM wip_requirement_operations
334: WHERE wip_entity_id = cp_wip_entity_id
335: AND operation_seq_num = cp_wip_op_seq_num
336: AND wip_supply_type <> 6;
337:

Line 597: FROM wip_requirement_operations wro

593:
594: For c_component_rec in
595: ( SELECT required_quantity ,quantity_per_assembly,inventory_item_id ,
596: component_sequence_id , 'W' item_type, comments
597: FROM wip_requirement_operations wro
598: WHERE wro.wip_entity_id = c_po_dist.wip_entity_id
599: AND wro.operation_seq_num = c_po_dist.wip_operation_seq_num
600: AND wip_supply_type <> 6
601: UNION