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_XDOCK_PEGGING_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 2010: wms_license_plate_numbers wlpn

2006: mtrl.project_id AS project_id,
2007: mtrl.task_id AS task_id,
2008: mtrl.lpn_id AS lpn_id
2009: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
2010: wms_license_plate_numbers wlpn
2011: WHERE mtrl.header_id = mtrh.header_id
2012: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
2013: AND mtrl.organization_id = l_organization_id
2014: AND mtrl.inventory_item_id = l_inventory_item_id

Line 2030: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6

2026: AND NVL(mtrl.wms_process_flag, 1) = 1
2027: AND NVL(mtrl.reference, 'non-RMA') <> 'ORDER_LINE_ID'
2028: AND mtrl.lpn_id = wlpn.lpn_id
2029: AND wlpn.lpn_context = 3
2030: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
2031: -- can be used in case the SQL optimizer uses WLPN as the driving table.
2032: AND wlpn.organization_id = l_organization_id;
2033:
2034:

Line 2324: wms_license_plate_numbers wlpn

2320: mtrl.project_id AS project_id,
2321: mtrl.task_id AS task_id,
2322: mtrl.lpn_id AS lpn_id
2323: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
2324: wms_license_plate_numbers wlpn
2325: WHERE mtrl.header_id = mtrh.header_id
2326: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
2327: AND mtrl.organization_id = l_organization_id
2328: AND mtrl.inventory_item_id = l_inventory_item_id

Line 2349: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6

2345: (NVL(mtrl.project_id, -999) = NVL(p_project_id, -999) AND
2346: NVL(mtrl.task_id, -999) = NVL(p_task_id, -999)))
2347: AND mtrl.lpn_id = wlpn.lpn_id
2348: AND wlpn.lpn_context = 3
2349: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
2350: -- can be used in case the SQL optimizer uses WLPN as the driving table.
2351: AND wlpn.organization_id = l_organization_id
2352: ORDER BY ABS(mtrl.primary_quantity - p_rsv_prim_qty) ASC
2353: FOR UPDATE OF mtrl.line_id NOWAIT;

Line 6613: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn

6609: NVL(msi.reservable_type, 1) AS reservable_type,
6610: NVL(msi.lot_control_code, 1) AS lot_control_code,
6611: NVL(msi.lot_divisible_flag, 'Y') AS lot_divisible_flag,
6612: wlpn.lpn_context AS lpn_context
6613: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn
6614: WHERE mtrl.line_id = p_move_order_line_id
6615: AND mtrl.organization_id = l_organization_id
6616: -- Modified the line below to use an IN instead of <>
6617: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

Line 6632: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6

6628: AND mtrl.inventory_item_id = msi.inventory_item_id
6629: AND mtrl.organization_id = msi.organization_id
6630: AND mtrl.lpn_id = wlpn.lpn_id
6631: AND wlpn.lpn_context IN (2, 3) -- WIP or RCV
6632: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
6633: -- can be used in case the SQL optimizer uses WLPN as the driving table.
6634: AND wlpn.organization_id = l_organization_id
6635: FOR UPDATE OF mtrl.line_id NOWAIT;
6636:

Line 6661: wms_license_plate_numbers wlpn

6657: p_operation_seq_num NUMBER,
6658: p_repetitive_schedule_id NUMBER) IS
6659: SELECT mtrl.line_id
6660: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
6661: wms_license_plate_numbers wlpn
6662: WHERE mtrl.header_id = mtrh.header_id
6663: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
6664: AND mtrl.organization_id = l_organization_id
6665: AND mtrl.inventory_item_id = l_inventory_item_id

Line 6681: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6

6677: AND NVL(mtrl.wms_process_flag, 1) = 1
6678: AND NVL(mtrl.reference, 'non-RMA') <> 'ORDER_LINE_ID'
6679: AND mtrl.lpn_id = wlpn.lpn_id
6680: AND wlpn.lpn_context = p_lpn_context
6681: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
6682: -- can be used in case the SQL optimizer uses WLPN as the driving table.
6683: AND wlpn.organization_id = l_organization_id
6684: AND (p_lpn_context = 3 OR -- RCV
6685: (p_lpn_context = 2 AND -- WIP

Line 7022: wms_license_plate_numbers wlpn

7018: p_demand_source_header_id NUMBER,
7019: p_demand_source_line_id NUMBER) IS
7020: SELECT NVL(SUM(mtrl.primary_quantity), 0)
7021: FROM mtl_txn_request_lines mtrl, wsh_delivery_details wdd,
7022: wms_license_plate_numbers wlpn
7023: WHERE mtrl.organization_id = l_organization_id
7024: AND mtrl.inventory_item_id = l_inventory_item_id
7025: -- Modified the line below to use an IN instead of <> so the
7026: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.

Line 7038: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6

7034: -- AND NVL(mtrl.txn_source_line_id, -999) = NVL(p_operation_seq_num, -999)
7035: -- AND NVL(mtrl.reference_id, -999) = NVL(p_repetitive_schedule_id, -999)
7036: AND mtrl.lpn_id = wlpn.lpn_id
7037: AND wlpn.lpn_context = 2 -- WIP
7038: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
7039: -- can be used in case the SQL optimizer uses WLPN as the driving table.
7040: AND wlpn.organization_id = l_organization_id
7041: AND mtrl.crossdock_type = 1 -- Crossdocked to OE demand
7042: AND mtrl.backorder_delivery_detail_id = wdd.delivery_detail_id