APPS.WMS_PICKING_PKG dependencies on INV_PROJECT

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

1028: , mmtt.transaction_quantity
1029: , mmtt.transaction_uom
1030: , mmtt.locator_id locator_id
1031: , mmtt.subinventory_code
1032: , inv_project.get_locsegs(mmtt.locator_id, mmtt.organization_id) loc
1033: -- 11
1034: , msik.concatenated_segments item
1035: , mmtt.transaction_temp_id
1036: , mmtt.transfer_subinventory

Line 1059: , inv_project.get_project_id

1055: --31
1056: , mmtt.transaction_source_type_id
1057: , NVL(mmtt.allocated_lpn_id, 0)
1058: , mmtt.pick_slip_number
1059: , inv_project.get_project_id
1060: , inv_project.get_task_id
1061: , inv_project.get_project_number
1062: , inv_project.get_task_number
1063: , mmtt.transaction_action_id

Line 1060: , inv_project.get_task_id

1056: , mmtt.transaction_source_type_id
1057: , NVL(mmtt.allocated_lpn_id, 0)
1058: , mmtt.pick_slip_number
1059: , inv_project.get_project_id
1060: , inv_project.get_task_id
1061: , inv_project.get_project_number
1062: , inv_project.get_task_number
1063: , mmtt.transaction_action_id
1064: , wdt.device_request_id

Line 1061: , inv_project.get_project_number

1057: , NVL(mmtt.allocated_lpn_id, 0)
1058: , mmtt.pick_slip_number
1059: , inv_project.get_project_id
1060: , inv_project.get_task_id
1061: , inv_project.get_project_number
1062: , inv_project.get_task_number
1063: , mmtt.transaction_action_id
1064: , wdt.device_request_id
1065: , l_sl_alloc_flag

Line 1062: , inv_project.get_task_number

1058: , mmtt.pick_slip_number
1059: , inv_project.get_project_id
1060: , inv_project.get_task_id
1061: , inv_project.get_project_number
1062: , inv_project.get_task_number
1063: , mmtt.transaction_action_id
1064: , wdt.device_request_id
1065: , l_sl_alloc_flag
1066: --41

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

1139: , mmtt.transaction_quantity
1140: , mmtt.transaction_uom
1141: , mmtt.locator_id locator_id
1142: , mmtt.subinventory_code
1143: , inv_project.get_locsegs(mmtt.locator_id, mmtt.organization_id) loc
1144: -- 11
1145: , msik.concatenated_segments item
1146: , mmtt.transaction_temp_id
1147: , mmtt.transfer_subinventory

Line 1170: , inv_project.get_project_id

1166: --31
1167: , mmtt.transaction_source_type_id
1168: , NVL(mmtt.allocated_lpn_id, 0)
1169: , mmtt.pick_slip_number
1170: , inv_project.get_project_id
1171: , inv_project.get_task_id
1172: , inv_project.get_project_number
1173: , inv_project.get_task_number
1174: , mmtt.transaction_action_id

Line 1171: , inv_project.get_task_id

1167: , mmtt.transaction_source_type_id
1168: , NVL(mmtt.allocated_lpn_id, 0)
1169: , mmtt.pick_slip_number
1170: , inv_project.get_project_id
1171: , inv_project.get_task_id
1172: , inv_project.get_project_number
1173: , inv_project.get_task_number
1174: , mmtt.transaction_action_id
1175: , wdt.device_request_id

Line 1172: , inv_project.get_project_number

1168: , NVL(mmtt.allocated_lpn_id, 0)
1169: , mmtt.pick_slip_number
1170: , inv_project.get_project_id
1171: , inv_project.get_task_id
1172: , inv_project.get_project_number
1173: , inv_project.get_task_number
1174: , mmtt.transaction_action_id
1175: , wdt.device_request_id
1176: , l_sl_alloc_flag

Line 1173: , inv_project.get_task_number

1169: , mmtt.pick_slip_number
1170: , inv_project.get_project_id
1171: , inv_project.get_task_id
1172: , inv_project.get_project_number
1173: , inv_project.get_task_number
1174: , mmtt.transaction_action_id
1175: , wdt.device_request_id
1176: , l_sl_alloc_flag
1177: --41

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

1467: , msik.primary_uom_code
1468: , mmtt.transfer_subinventory transfer_sub
1469: , NVL(msi.dropping_order, 0) sub_dropping_order
1470: , NVL(msi.picking_order, 0) sub_picking_order
1471: , inv_project.get_locsegs(mmtt.transfer_to_location,
1472: mmtt.organization_id) transfer_loc
1473: , NVL(mil.dropping_order, 0) loc_dropping_order
1474: , NVL(mil.picking_order, 0) loc_picking_order
1475: , mmtt.transaction_type_id

Line 1480: , inv_project.get_project_id

1476: , mmtt.wip_entity_type
1477: , wdt.priority
1478: , wdt.task_id taskid
1479: , wdt.task_type
1480: , inv_project.get_project_id
1481: , inv_project.get_project_number
1482: , inv_project.get_task_id
1483: , inv_project.get_task_number
1484: , 0 wip_entity_id

Line 1481: , inv_project.get_project_number

1477: , wdt.priority
1478: , wdt.task_id taskid
1479: , wdt.task_type
1480: , inv_project.get_project_id
1481: , inv_project.get_project_number
1482: , inv_project.get_task_id
1483: , inv_project.get_task_number
1484: , 0 wip_entity_id
1485: , 0 repetitive_schedule_id

Line 1482: , inv_project.get_task_id

1478: , wdt.task_id taskid
1479: , wdt.task_type
1480: , inv_project.get_project_id
1481: , inv_project.get_project_number
1482: , inv_project.get_task_id
1483: , inv_project.get_task_number
1484: , 0 wip_entity_id
1485: , 0 repetitive_schedule_id
1486: , 0 operation_seq_num

Line 1483: , inv_project.get_task_number

1479: , wdt.task_type
1480: , inv_project.get_project_id
1481: , inv_project.get_project_number
1482: , inv_project.get_task_id
1483: , inv_project.get_task_number
1484: , 0 wip_entity_id
1485: , 0 repetitive_schedule_id
1486: , 0 operation_seq_num
1487: , mmtt.transfer_to_location --Bug#2756609

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

1573: , mmtt.transaction_quantity
1574: , mmtt.transaction_uom
1575: , mmtt.locator_id
1576: , mmtt.subinventory_code
1577: , nvl(inv_project.get_locsegs(mmtt.transfer_to_location, mmtt.organization_id),'') loc
1578: , msik.concatenated_segments item
1579: , mmtt.transaction_temp_id
1580: , mmtt.transfer_subinventory
1581: , mmtt.transfer_to_location

Line 1588: , inv_project.get_project_id

1584: , mmtt.transaction_source_type_id
1585: , wdt.priority priority
1586: , wdt.task_id taskid
1587: , wdt.task_type task_type
1588: , inv_project.get_project_id
1589: , inv_project.get_project_number
1590: , inv_project.get_task_id
1591: , inv_project.get_task_number
1592: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */

Line 1589: , inv_project.get_project_number

1585: , wdt.priority priority
1586: , wdt.task_id taskid
1587: , wdt.task_type task_type
1588: , inv_project.get_project_id
1589: , inv_project.get_project_number
1590: , inv_project.get_task_id
1591: , inv_project.get_task_number
1592: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1593: WHERE wdt.organization_id = p_organization_id

Line 1590: , inv_project.get_task_id

1586: , wdt.task_id taskid
1587: , wdt.task_type task_type
1588: , inv_project.get_project_id
1589: , inv_project.get_project_number
1590: , inv_project.get_task_id
1591: , inv_project.get_task_number
1592: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1593: WHERE wdt.organization_id = p_organization_id
1594: AND wdt.status IN (3, 4)

Line 1591: , inv_project.get_task_number

1587: , wdt.task_type task_type
1588: , inv_project.get_project_id
1589: , inv_project.get_project_number
1590: , inv_project.get_task_id
1591: , inv_project.get_task_number
1592: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt, mtl_system_items_vl msik /* Bug 5581528 */
1593: WHERE wdt.organization_id = p_organization_id
1594: AND wdt.status IN (3, 4)
1595: AND wdt.task_type IN (1, 4, 5, 7)