DBA Data[Home] [Help]

APPS.INV_WIP_PICKING_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1844: FROM wip_requirement_operations

1840: AND wip_entity_id = p_wip_entity_id;
1841:
1842: CURSOR c_push_vs_pull IS
1843: SELECT decode(wip_supply_type,1,'PUSH',2,'PULL',3,'PULL')
1844: FROM wip_requirement_operations
1845: WHERE p_rep_schedule_id IS null
1846: AND wip_entity_id = p_wip_entity_id
1847: AND inventory_item_id = p_inventory_item_id
1848: AND operation_seq_num = p_operation_seq_num

Line 1852: FROM wip_requirement_operations

1848: AND operation_seq_num = p_operation_seq_num
1849: AND organization_id = p_organization_id
1850: UNION ALL
1851: SELECT decode(wip_supply_type,1,'PUSH',2,'PULL',3,'PULL')
1852: FROM wip_requirement_operations
1853: WHERE p_rep_schedule_id IS NOT NULL
1854: AND wip_entity_id = p_wip_entity_id
1855: AND inventory_item_id = p_inventory_item_id
1856: AND operation_seq_num = p_operation_seq_num