DBA Data[Home] [Help]

APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on WIP_REQUIREMENT_OPERATIONS

Line 586: FROM WIP_REQUIREMENT_OPERATIONS WRO

582:
583: CURSOR phan_comp_qty
584: IS
585: SELECT WRO.QUANTITY_PER_ASSEMBLY,WRO.COMPONENT_YIELD_FACTOR
586: FROM WIP_REQUIREMENT_OPERATIONS WRO
587: WHERE WRO.WIP_ENTITY_ID = p_wip_entity_id
588: AND WRO.INVENTORY_ITEM_ID = p_phantom_item_id
589: AND WRO.OPERATION_SEQ_NUM = -p_op_seq_num
590: AND WRO.ORGANIZATION_ID = p_org_id