eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 17960: WMS_LICENSE_PLATE_NUMBERS WLPN,

17956: wwl.wave_header_id
17957: FROM
17958: WSH_DELIVERY_DETAILS WDD,
17959: WMS_WP_WAVE_LINES WWL,
17960: WMS_LICENSE_PLATE_NUMBERS WLPN,
17961: WSH_DELIVERY_ASSIGNMENTS WDA,
17962: mtl_item_locations_kfv mil,
17963: wsh_Delivery_details wdd2
17964: WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID

Line 18161: WMS_LICENSE_PLATE_NUMBERS WLPN,

18157: WSH_NEW_DELIVERIES WND,
18158: MTL_SYSTEM_ITEMS_KFV MSIV,
18159: WSH_CARRIERS WC,
18160: MTL_PARAMETERS MP,
18161: WMS_LICENSE_PLATE_NUMBERS WLPN,
18162: WSH_DELIVERY_ASSIGNMENTS WDA,
18163: WSH_TRIP_STOPS WTS,
18164: WSH_DELIVERY_LEGS WLG,
18165: mtl_item_locations_kfv mil,

Line 18267: FROM WMS_LICENSE_PLATE_NUMBERS

18263: TRANSACTION_UOM,
18264: TRANSACTION_QUANTITY)
18265: SELECT /*+ use_nl(WWL,WDD,mmtt) index(mmtt) */ DISTINCT WDT.TASK_ID,
18266: (SELECT LICENSE_PLATE_NUMBER
18267: FROM WMS_LICENSE_PLATE_NUMBERS
18268: WHERE LPN_ID = MMTT.TRANSFER_LPN_ID) TO_LPN,
18269: MMTT.TRANSFER_LPN_ID TO_LPN_ID,
18270: mmtt.transaction_temp_id,
18271: mmtt.transaction_type_id,

Line 18358: FROM WMS_LICENSE_PLATE_NUMBERS

18354: MMTT.DEPARTMENT_CODE,
18355: 'N' CHILD_TASKS,
18356: null num_of_child_tasks,
18357: (SELECT LICENSE_PLATE_NUMBER
18358: FROM WMS_LICENSE_PLATE_NUMBERS
18359: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18360: (SELECT LICENSE_PLATE_NUMBER
18361: FROM WMS_LICENSE_PLATE_NUMBERS
18362: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,

Line 18361: FROM WMS_LICENSE_PLATE_NUMBERS

18357: (SELECT LICENSE_PLATE_NUMBER
18358: FROM WMS_LICENSE_PLATE_NUMBERS
18359: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18360: (SELECT LICENSE_PLATE_NUMBER
18361: FROM WMS_LICENSE_PLATE_NUMBERS
18362: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18363: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id),
18364: (SELECT LICENSE_PLATE_NUMBER
18365: FROM WMS_LICENSE_PLATE_NUMBERS

Line 18365: FROM WMS_LICENSE_PLATE_NUMBERS

18361: FROM WMS_LICENSE_PLATE_NUMBERS
18362: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18363: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id),
18364: (SELECT LICENSE_PLATE_NUMBER
18365: FROM WMS_LICENSE_PLATE_NUMBERS
18366: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18367: WDT.DISPATCHED_TIME,
18368: WDT.EQUIPMENT_ID,
18369: (SELECT LICENSE_PLATE_NUMBER

Line 18370: FROM WMS_LICENSE_PLATE_NUMBERS

18366: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18367: WDT.DISPATCHED_TIME,
18368: WDT.EQUIPMENT_ID,
18369: (SELECT LICENSE_PLATE_NUMBER
18370: FROM WMS_LICENSE_PLATE_NUMBERS
18371: WHERE LPN_ID = MMTT.LPN_ID) FROM_LPN,
18372: MMTT.PARENT_LINE_ID,
18373: mmtt.move_order_line_id,
18374: MMTT.PICK_SLIP_NUMBER,

Line 18376: FROM WMS_LICENSE_PLATE_NUMBERS

18372: MMTT.PARENT_LINE_ID,
18373: mmtt.move_order_line_id,
18374: MMTT.PICK_SLIP_NUMBER,
18375: (SELECT LICENSE_PLATE_NUMBER
18376: FROM WMS_LICENSE_PLATE_NUMBERS
18377: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18378: mmtt.transaction_uom,
18379: mmtt.transaction_quantity
18380: FROM mtl_material_transactions_temp mmtt,

Line 18416: FROM WMS_LICENSE_PLATE_NUMBERS

18412: union
18413: --12736677 now include separate select for the bulk tasks
18414: SELECT /*+ use_nl(WWL,WDD,mmtt) index(mmtt) */ DISTINCT WDT.TASK_ID,
18415: (SELECT LICENSE_PLATE_NUMBER
18416: FROM WMS_LICENSE_PLATE_NUMBERS
18417: WHERE LPN_ID = MMTT.TRANSFER_LPN_ID) TO_LPN,
18418: MMTT.TRANSFER_LPN_ID TO_LPN_ID,
18419: mmtt.transaction_temp_id,
18420: mmtt.transaction_type_id,

Line 18489: FROM WMS_LICENSE_PLATE_NUMBERS

18485: MMTT.DEPARTMENT_CODE,
18486: 'N' CHILD_TASKS,
18487: (select count(1) from mtl_material_transactions_temp where parent_line_id = mmtt.transaction_temp_id and transaction_temp_id <> mmtt.transaction_temp_id) num_of_child_tasks,
18488: (SELECT LICENSE_PLATE_NUMBER
18489: FROM WMS_LICENSE_PLATE_NUMBERS
18490: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18491: (SELECT LICENSE_PLATE_NUMBER
18492: FROM WMS_LICENSE_PLATE_NUMBERS
18493: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,

Line 18492: FROM WMS_LICENSE_PLATE_NUMBERS

18488: (SELECT LICENSE_PLATE_NUMBER
18489: FROM WMS_LICENSE_PLATE_NUMBERS
18490: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18491: (SELECT LICENSE_PLATE_NUMBER
18492: FROM WMS_LICENSE_PLATE_NUMBERS
18493: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18494: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id),
18495: (SELECT LICENSE_PLATE_NUMBER
18496: FROM WMS_LICENSE_PLATE_NUMBERS

Line 18496: FROM WMS_LICENSE_PLATE_NUMBERS

18492: FROM WMS_LICENSE_PLATE_NUMBERS
18493: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18494: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id),
18495: (SELECT LICENSE_PLATE_NUMBER
18496: FROM WMS_LICENSE_PLATE_NUMBERS
18497: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18498: WDT.DISPATCHED_TIME,
18499: WDT.EQUIPMENT_ID,
18500: (SELECT LICENSE_PLATE_NUMBER

Line 18501: FROM WMS_LICENSE_PLATE_NUMBERS

18497: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18498: WDT.DISPATCHED_TIME,
18499: WDT.EQUIPMENT_ID,
18500: (SELECT LICENSE_PLATE_NUMBER
18501: FROM WMS_LICENSE_PLATE_NUMBERS
18502: WHERE LPN_ID = MMTT.LPN_ID) FROM_LPN,
18503: MMTT.PARENT_LINE_ID,
18504: mmtt.move_order_line_id,
18505: MMTT.PICK_SLIP_NUMBER,

Line 18507: FROM WMS_LICENSE_PLATE_NUMBERS

18503: MMTT.PARENT_LINE_ID,
18504: mmtt.move_order_line_id,
18505: MMTT.PICK_SLIP_NUMBER,
18506: (SELECT LICENSE_PLATE_NUMBER
18507: FROM WMS_LICENSE_PLATE_NUMBERS
18508: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18509: mmtt.transaction_uom,
18510: mmtt.transaction_quantity
18511: FROM mtl_material_transactions_temp mmtt,

Line 18548: FROM WMS_LICENSE_PLATE_NUMBERS

18544: AND wdt.person_resource_id = br1.resource_id(+)
18545: union
18546: SELECT DISTINCT WDT.TASK_ID,
18547: (SELECT LICENSE_PLATE_NUMBER
18548: FROM WMS_LICENSE_PLATE_NUMBERS
18549: WHERE LPN_ID = MMTT.TRANSFER_LPN_ID) TO_LPN,
18550: MMTT.TRANSFER_LPN_ID TO_LPN_ID,
18551: mmtt.transaction_temp_id,
18552: mmtt.transaction_type_id,

Line 18639: FROM WMS_LICENSE_PLATE_NUMBERS

18635: MMTT.DEPARTMENT_CODE,
18636: DECODE(PARENT_TRANSACTION_TEMP_ID, NULL, 'N', 'Y') CHILD_TASKS,
18637: null num_of_child_tasks,
18638: (SELECT LICENSE_PLATE_NUMBER
18639: FROM WMS_LICENSE_PLATE_NUMBERS
18640: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18641: (SELECT LICENSE_PLATE_NUMBER
18642: FROM WMS_LICENSE_PLATE_NUMBERS
18643: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,

Line 18642: FROM WMS_LICENSE_PLATE_NUMBERS

18638: (SELECT LICENSE_PLATE_NUMBER
18639: FROM WMS_LICENSE_PLATE_NUMBERS
18640: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18641: (SELECT LICENSE_PLATE_NUMBER
18642: FROM WMS_LICENSE_PLATE_NUMBERS
18643: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18644: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id), --bug12642410
18645: (SELECT LICENSE_PLATE_NUMBER
18646: FROM WMS_LICENSE_PLATE_NUMBERS

Line 18646: FROM WMS_LICENSE_PLATE_NUMBERS

18642: FROM WMS_LICENSE_PLATE_NUMBERS
18643: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18644: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id), --bug12642410
18645: (SELECT LICENSE_PLATE_NUMBER
18646: FROM WMS_LICENSE_PLATE_NUMBERS
18647: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18648: WDT.DISPATCHED_TIME,
18649: WDT.EQUIPMENT_ID,
18650: (SELECT LICENSE_PLATE_NUMBER

Line 18651: FROM WMS_LICENSE_PLATE_NUMBERS

18647: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18648: WDT.DISPATCHED_TIME,
18649: WDT.EQUIPMENT_ID,
18650: (SELECT LICENSE_PLATE_NUMBER
18651: FROM WMS_LICENSE_PLATE_NUMBERS
18652: WHERE LPN_ID = MMTT.LPN_ID) FROM_LPN,
18653: MMTT.PARENT_LINE_ID,
18654: mmtt.move_order_line_id,
18655: MMTT.PICK_SLIP_NUMBER,

Line 18657: FROM WMS_LICENSE_PLATE_NUMBERS

18653: MMTT.PARENT_LINE_ID,
18654: mmtt.move_order_line_id,
18655: MMTT.PICK_SLIP_NUMBER,
18656: (SELECT LICENSE_PLATE_NUMBER
18657: FROM WMS_LICENSE_PLATE_NUMBERS
18658: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18659: mmtt.transaction_uom,
18660: mmtt.transaction_quantity
18661: FROM mtl_material_transactions_temp mmtt,

Line 18701: FROM WMS_LICENSE_PLATE_NUMBERS

18697: AND wdt.person_resource_id = br1.resource_id(+)
18698: union
18699: SELECT DISTINCT wdth.TASK_ID,
18700: (SELECT LICENSE_PLATE_NUMBER
18701: FROM WMS_LICENSE_PLATE_NUMBERS
18702: WHERE LPN_ID = mmt.TRANSFER_LPN_ID) TO_LPN,
18703: mmt.TRANSFER_LPN_ID TO_LPN_ID,
18704: mmt.transaction_id,
18705: mmt.transaction_type_id,

Line 18809: FROM WMS_LICENSE_PLATE_NUMBERS

18805: ' ' ALLOCATED_LPN,
18806: ' ' CARTONIZED_LPN,
18807: ' ' CONTAINER_ITEM_ID,
18808: (SELECT LICENSE_PLATE_NUMBER
18809: FROM WMS_LICENSE_PLATE_NUMBERS
18810: WHERE LPN_ID = mmt.CONTENT_LPN_ID) CONTENT_LPN,
18811: wdth.DISPATCHED_TIME,
18812: wdth.EQUIPMENT_ID,
18813: (SELECT LICENSE_PLATE_NUMBER

Line 18814: FROM WMS_LICENSE_PLATE_NUMBERS

18810: WHERE LPN_ID = mmt.CONTENT_LPN_ID) CONTENT_LPN,
18811: wdth.DISPATCHED_TIME,
18812: wdth.EQUIPMENT_ID,
18813: (SELECT LICENSE_PLATE_NUMBER
18814: FROM WMS_LICENSE_PLATE_NUMBERS
18815: WHERE LPN_ID = mmt.LPN_ID) FROM_LPN,
18816: wdth.parent_transaction_id,
18817: mmt.move_order_line_id,
18818: mmt.PICK_SLIP_NUMBER,

Line 18820: FROM WMS_LICENSE_PLATE_NUMBERS

18816: wdth.parent_transaction_id,
18817: mmt.move_order_line_id,
18818: mmt.PICK_SLIP_NUMBER,
18819: (SELECT LICENSE_PLATE_NUMBER
18820: FROM WMS_LICENSE_PLATE_NUMBERS
18821: WHERE LPN_ID = mmt.CONTENT_LPN_ID) PICKED_LPN,
18822: mmt.transaction_uom,
18823: abs(mmt.transaction_quantity)
18824: FROM mtl_material_transactions mmt,

Line 18884: FROM WMS_LICENSE_PLATE_NUMBERS

18880: AND wdth.person_resource_id = br1.resource_id(+)
18881: union -- For Crossdocked Tasks
18882: SELECT DISTINCT WDT.TASK_ID,
18883: (SELECT LICENSE_PLATE_NUMBER
18884: FROM WMS_LICENSE_PLATE_NUMBERS
18885: WHERE LPN_ID = MMTT.TRANSFER_LPN_ID) TO_LPN,
18886: MMTT.TRANSFER_LPN_ID TO_LPN_ID,
18887: mmtt.transaction_temp_id,
18888: mmtt.transaction_type_id,

Line 18976: FROM WMS_LICENSE_PLATE_NUMBERS

18972: MMTT.DEPARTMENT_CODE,
18973: DECODE(PARENT_TRANSACTION_TEMP_ID, NULL, 'N', 'Y') CHILD_TASKS,
18974: null num_of_child_tasks,
18975: (SELECT LICENSE_PLATE_NUMBER
18976: FROM WMS_LICENSE_PLATE_NUMBERS
18977: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18978: (SELECT LICENSE_PLATE_NUMBER
18979: FROM WMS_LICENSE_PLATE_NUMBERS
18980: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,

Line 18979: FROM WMS_LICENSE_PLATE_NUMBERS

18975: (SELECT LICENSE_PLATE_NUMBER
18976: FROM WMS_LICENSE_PLATE_NUMBERS
18977: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18978: (SELECT LICENSE_PLATE_NUMBER
18979: FROM WMS_LICENSE_PLATE_NUMBERS
18980: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18981: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id), --bug12642410
18982: (SELECT LICENSE_PLATE_NUMBER
18983: FROM WMS_LICENSE_PLATE_NUMBERS

Line 18983: FROM WMS_LICENSE_PLATE_NUMBERS

18979: FROM WMS_LICENSE_PLATE_NUMBERS
18980: WHERE LPN_ID = MMTT.CARTONIZATION_ID) CARTONIZED_LPN,
18981: (SELECT concatenated_segments FROM mtl_system_items_kfv WHERE inventory_item_id= MMTT.CONTAINER_ITEM_ID AND organization_id=mmtt.organization_id), --bug12642410
18982: (SELECT LICENSE_PLATE_NUMBER
18983: FROM WMS_LICENSE_PLATE_NUMBERS
18984: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18985: WDT.DISPATCHED_TIME,
18986: WDT.EQUIPMENT_ID,
18987: (SELECT LICENSE_PLATE_NUMBER

Line 18988: FROM WMS_LICENSE_PLATE_NUMBERS

18984: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) CONTENT_LPN,
18985: WDT.DISPATCHED_TIME,
18986: WDT.EQUIPMENT_ID,
18987: (SELECT LICENSE_PLATE_NUMBER
18988: FROM WMS_LICENSE_PLATE_NUMBERS
18989: WHERE LPN_ID = MMTT.LPN_ID) FROM_LPN,
18990: MMTT.PARENT_LINE_ID,
18991: mmtt.move_order_line_id,
18992: MMTT.PICK_SLIP_NUMBER,

Line 18994: FROM WMS_LICENSE_PLATE_NUMBERS

18990: MMTT.PARENT_LINE_ID,
18991: mmtt.move_order_line_id,
18992: MMTT.PICK_SLIP_NUMBER,
18993: (SELECT LICENSE_PLATE_NUMBER
18994: FROM WMS_LICENSE_PLATE_NUMBERS
18995: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18996: mmtt.transaction_uom,
18997: mmtt.transaction_quantity
18998: FROM mtl_material_transactions_temp mmtt,

Line 19034: FROM WMS_LICENSE_PLATE_NUMBERS

19030: AND wdt.person_resource_id = br1.resource_id(+)
19031: union -- Crossdocked Tasks completed
19032: SELECT DISTINCT wdth.TASK_ID,
19033: (SELECT LICENSE_PLATE_NUMBER
19034: FROM WMS_LICENSE_PLATE_NUMBERS
19035: WHERE LPN_ID = wdth.TRANSFER_LPN_ID) TO_LPN,
19036: wdth.TRANSFER_LPN_ID TO_LPN_ID,
19037: wdth.transaction_id,
19038: wdth.transaction_type_id,

Line 19142: FROM WMS_LICENSE_PLATE_NUMBERS

19138: ' ' ALLOCATED_LPN,
19139: ' ' CARTONIZED_LPN,
19140: ' ' CONTAINER_ITEM_ID,
19141: (SELECT LICENSE_PLATE_NUMBER
19142: FROM WMS_LICENSE_PLATE_NUMBERS
19143: WHERE LPN_ID = wdth.CONTENT_LPN_ID) CONTENT_LPN,
19144: wdth.DISPATCHED_TIME,
19145: wdth.EQUIPMENT_ID,
19146: (SELECT LICENSE_PLATE_NUMBER

Line 19147: FROM WMS_LICENSE_PLATE_NUMBERS

19143: WHERE LPN_ID = wdth.CONTENT_LPN_ID) CONTENT_LPN,
19144: wdth.DISPATCHED_TIME,
19145: wdth.EQUIPMENT_ID,
19146: (SELECT LICENSE_PLATE_NUMBER
19147: FROM WMS_LICENSE_PLATE_NUMBERS
19148: WHERE LPN_ID = wdth.LPN_ID) FROM_LPN,
19149: wdth.parent_transaction_id,
19150: wdth.move_order_line_id,
19151: to_number(null),

Line 19153: FROM WMS_LICENSE_PLATE_NUMBERS

19149: wdth.parent_transaction_id,
19150: wdth.move_order_line_id,
19151: to_number(null),
19152: (SELECT LICENSE_PLATE_NUMBER
19153: FROM WMS_LICENSE_PLATE_NUMBERS
19154: WHERE LPN_ID = wdth.CONTENT_LPN_ID) PICKED_LPN,
19155: wdth.transaction_uom_code,
19156: abs(wdth.transaction_quantity)
19157: FROM