APPS.WMS_PICKING_PKG dependencies on INV_PROJECT

Line 1271: , inv_project.get_locsegs(mmtt.locator_id, mmtt.organization_id) loc

1267: , mmtt.transaction_uom) --muom:sk
1268: -- , mmtt.transaction_uom --muom:sk
1269: , mmtt.locator_id locator_id
1270: , mmtt.subinventory_code
1271: , inv_project.get_locsegs(mmtt.locator_id, mmtt.organization_id) loc
1272: -- 11
1273: , msik.concatenated_segments item
1274: , mmtt.transaction_temp_id
1275: , mmtt.transfer_subinventory

Line 1298: , inv_project.get_project_id

1294: --31
1295: , mmtt.transaction_source_type_id
1296: , NVL(mmtt.allocated_lpn_id, 0)
1297: , mmtt.pick_slip_number
1298: , inv_project.get_project_id
1299: , inv_project.get_task_id
1300: , inv_project.get_project_number
1301: , inv_project.get_task_number
1302: , mmtt.transaction_action_id

Line 1299: , inv_project.get_task_id

1295: , mmtt.transaction_source_type_id
1296: , NVL(mmtt.allocated_lpn_id, 0)
1297: , mmtt.pick_slip_number
1298: , inv_project.get_project_id
1299: , inv_project.get_task_id
1300: , inv_project.get_project_number
1301: , inv_project.get_task_number
1302: , mmtt.transaction_action_id
1303: , wdt.device_request_id

Line 1300: , inv_project.get_project_number

1296: , NVL(mmtt.allocated_lpn_id, 0)
1297: , mmtt.pick_slip_number
1298: , inv_project.get_project_id
1299: , inv_project.get_task_id
1300: , inv_project.get_project_number
1301: , inv_project.get_task_number
1302: , mmtt.transaction_action_id
1303: , wdt.device_request_id
1304: , l_sl_alloc_flag

Line 1301: , inv_project.get_task_number

1297: , mmtt.pick_slip_number
1298: , inv_project.get_project_id
1299: , inv_project.get_task_id
1300: , inv_project.get_project_number
1301: , inv_project.get_task_number
1302: , mmtt.transaction_action_id
1303: , wdt.device_request_id
1304: , l_sl_alloc_flag
1305: --41

Line 1398: , inv_project.get_locsegs(mmtt.locator_id, mmtt.organization_id) loc

1394: , mmtt.transaction_uom) --muom:sk
1395: -- , mmtt.transaction_uom --muom:sk
1396: , mmtt.locator_id locator_id
1397: , mmtt.subinventory_code
1398: , inv_project.get_locsegs(mmtt.locator_id, mmtt.organization_id) loc
1399: -- 11
1400: , msik.concatenated_segments item
1401: , mmtt.transaction_temp_id
1402: , mmtt.transfer_subinventory

Line 1425: , inv_project.get_project_id

1421: --31
1422: , mmtt.transaction_source_type_id
1423: , NVL(mmtt.allocated_lpn_id, 0)
1424: , mmtt.pick_slip_number
1425: , inv_project.get_project_id
1426: , inv_project.get_task_id
1427: , inv_project.get_project_number
1428: , inv_project.get_task_number
1429: , mmtt.transaction_action_id

Line 1426: , inv_project.get_task_id

1422: , mmtt.transaction_source_type_id
1423: , NVL(mmtt.allocated_lpn_id, 0)
1424: , mmtt.pick_slip_number
1425: , inv_project.get_project_id
1426: , inv_project.get_task_id
1427: , inv_project.get_project_number
1428: , inv_project.get_task_number
1429: , mmtt.transaction_action_id
1430: , wdt.device_request_id

Line 1427: , inv_project.get_project_number

1423: , NVL(mmtt.allocated_lpn_id, 0)
1424: , mmtt.pick_slip_number
1425: , inv_project.get_project_id
1426: , inv_project.get_task_id
1427: , inv_project.get_project_number
1428: , inv_project.get_task_number
1429: , mmtt.transaction_action_id
1430: , wdt.device_request_id
1431: , l_sl_alloc_flag

Line 1428: , inv_project.get_task_number

1424: , mmtt.pick_slip_number
1425: , inv_project.get_project_id
1426: , inv_project.get_task_id
1427: , inv_project.get_project_number
1428: , inv_project.get_task_number
1429: , mmtt.transaction_action_id
1430: , wdt.device_request_id
1431: , l_sl_alloc_flag
1432: --41

Line 1731: , inv_project.get_locsegs(mmtt.transfer_to_location,

1727: , msik.primary_uom_code
1728: , mmtt.transfer_subinventory transfer_sub
1729: , NVL(msi.dropping_order, 0) sub_dropping_order
1730: , NVL(msi.picking_order, 0) sub_picking_order
1731: , inv_project.get_locsegs(mmtt.transfer_to_location,
1732: mmtt.organization_id) transfer_loc
1733: , NVL(mil.dropping_order, 0) loc_dropping_order
1734: , NVL(mil.picking_order, 0) loc_picking_order
1735: , mmtt.transaction_type_id

Line 1740: , inv_project.get_project_id

1736: , mmtt.wip_entity_type
1737: , wdt.priority
1738: , wdt.task_id taskid
1739: , wdt.task_type
1740: , inv_project.get_project_id
1741: , inv_project.get_project_number
1742: , inv_project.get_task_id
1743: , inv_project.get_task_number
1744: , 0 wip_entity_id

Line 1741: , inv_project.get_project_number

1737: , wdt.priority
1738: , wdt.task_id taskid
1739: , wdt.task_type
1740: , inv_project.get_project_id
1741: , inv_project.get_project_number
1742: , inv_project.get_task_id
1743: , inv_project.get_task_number
1744: , 0 wip_entity_id
1745: , 0 repetitive_schedule_id

Line 1742: , inv_project.get_task_id

1738: , wdt.task_id taskid
1739: , wdt.task_type
1740: , inv_project.get_project_id
1741: , inv_project.get_project_number
1742: , inv_project.get_task_id
1743: , inv_project.get_task_number
1744: , 0 wip_entity_id
1745: , 0 repetitive_schedule_id
1746: , 0 operation_seq_num

Line 1743: , inv_project.get_task_number

1739: , wdt.task_type
1740: , inv_project.get_project_id
1741: , inv_project.get_project_number
1742: , inv_project.get_task_id
1743: , inv_project.get_task_number
1744: , 0 wip_entity_id
1745: , 0 repetitive_schedule_id
1746: , 0 operation_seq_num
1747: , mmtt.transfer_to_location --Bug#2756609

Line 1837: , nvl(inv_project.get_locsegs(mmtt.transfer_to_location, mmtt.organization_id),'') loc

1833: , mmtt.transaction_quantity
1834: , mmtt.transaction_uom
1835: , mmtt.locator_id
1836: , mmtt.subinventory_code
1837: , nvl(inv_project.get_locsegs(mmtt.transfer_to_location, mmtt.organization_id),'') loc
1838: , msik.concatenated_segments item
1839: , mmtt.transaction_temp_id
1840: , mmtt.transfer_subinventory
1841: , mmtt.transfer_to_location

Line 1848: , inv_project.get_project_id

1844: , mmtt.transaction_source_type_id
1845: , wdt.priority priority
1846: , wdt.task_id taskid
1847: , wdt.task_type task_type
1848: , inv_project.get_project_id
1849: , inv_project.get_project_number
1850: , inv_project.get_task_id
1851: , inv_project.get_task_number
1852: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */

Line 1849: , inv_project.get_project_number

1845: , wdt.priority priority
1846: , wdt.task_id taskid
1847: , wdt.task_type task_type
1848: , inv_project.get_project_id
1849: , inv_project.get_project_number
1850: , inv_project.get_task_id
1851: , inv_project.get_task_number
1852: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1853: WHERE wdt.organization_id = p_organization_id

Line 1850: , inv_project.get_task_id

1846: , wdt.task_id taskid
1847: , wdt.task_type task_type
1848: , inv_project.get_project_id
1849: , inv_project.get_project_number
1850: , inv_project.get_task_id
1851: , inv_project.get_task_number
1852: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1853: WHERE wdt.organization_id = p_organization_id
1854: AND wdt.status IN (3, 4)

Line 1851: , inv_project.get_task_number

1847: , wdt.task_type task_type
1848: , inv_project.get_project_id
1849: , inv_project.get_project_number
1850: , inv_project.get_task_id
1851: , inv_project.get_task_number
1852: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1853: WHERE wdt.organization_id = p_organization_id
1854: AND wdt.status IN (3, 4)
1855: AND wdt.task_type IN (1, 4, 5, 7)