DBA Data[Home] [Help]

APPS.INV_WIP_PICKING_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1796: FROM wip_requirement_operations

1792: AND wip_entity_id = p_wip_entity_id;
1793:
1794: CURSOR c_push_vs_pull IS
1795: SELECT decode(wip_supply_type,1,'PUSH',2,'PULL',3,'PULL')
1796: FROM wip_requirement_operations
1797: WHERE p_rep_schedule_id IS null
1798: AND wip_entity_id = p_wip_entity_id
1799: AND inventory_item_id = p_inventory_item_id
1800: AND operation_seq_num = p_operation_seq_num

Line 1804: FROM wip_requirement_operations

1800: AND operation_seq_num = p_operation_seq_num
1801: AND organization_id = p_organization_id
1802: UNION ALL
1803: SELECT decode(wip_supply_type,1,'PUSH',2,'PULL',3,'PULL')
1804: FROM wip_requirement_operations
1805: WHERE p_rep_schedule_id IS NOT NULL
1806: AND wip_entity_id = p_wip_entity_id
1807: AND inventory_item_id = p_inventory_item_id
1808: AND operation_seq_num = p_operation_seq_num