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 1985: wms_license_plate_numbers wlpn

1981: mtrl.project_id AS project_id,
1982: mtrl.task_id AS task_id,
1983: mtrl.lpn_id AS lpn_id
1984: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
1985: wms_license_plate_numbers wlpn
1986: WHERE mtrl.header_id = mtrh.header_id
1987: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1988: AND mtrl.organization_id = l_organization_id
1989: AND mtrl.inventory_item_id = l_inventory_item_id

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

2001: AND NVL(mtrl.wms_process_flag, 1) = 1
2002: AND NVL(mtrl.reference, 'non-RMA') <> 'ORDER_LINE_ID'
2003: AND mtrl.lpn_id = wlpn.lpn_id
2004: AND wlpn.lpn_context = 3
2005: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
2006: -- can be used in case the SQL optimizer uses WLPN as the driving table.
2007: AND wlpn.organization_id = l_organization_id;
2008:
2009:

Line 2299: wms_license_plate_numbers wlpn

2295: mtrl.project_id AS project_id,
2296: mtrl.task_id AS task_id,
2297: mtrl.lpn_id AS lpn_id
2298: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
2299: wms_license_plate_numbers wlpn
2300: WHERE mtrl.header_id = mtrh.header_id
2301: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
2302: AND mtrl.organization_id = l_organization_id
2303: AND mtrl.inventory_item_id = l_inventory_item_id

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

2320: (NVL(mtrl.project_id, -999) = NVL(p_project_id, -999) AND
2321: NVL(mtrl.task_id, -999) = NVL(p_task_id, -999)))
2322: AND mtrl.lpn_id = wlpn.lpn_id
2323: AND wlpn.lpn_context = 3
2324: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
2325: -- can be used in case the SQL optimizer uses WLPN as the driving table.
2326: AND wlpn.organization_id = l_organization_id
2327: ORDER BY ABS(mtrl.primary_quantity - p_rsv_prim_qty) ASC
2328: FOR UPDATE OF mtrl.line_id NOWAIT;

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

6434: NVL(msi.reservable_type, 1) AS reservable_type,
6435: NVL(msi.lot_control_code, 1) AS lot_control_code,
6436: NVL(msi.lot_divisible_flag, 'Y') AS lot_divisible_flag,
6437: wlpn.lpn_context AS lpn_context
6438: FROM mtl_txn_request_lines mtrl, mtl_system_items msi, wms_license_plate_numbers wlpn
6439: WHERE mtrl.line_id = p_move_order_line_id
6440: AND mtrl.organization_id = l_organization_id
6441: -- Modified the line below to use an IN instead of <>
6442: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

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

6453: AND mtrl.inventory_item_id = msi.inventory_item_id
6454: AND mtrl.organization_id = msi.organization_id
6455: AND mtrl.lpn_id = wlpn.lpn_id
6456: AND wlpn.lpn_context IN (2, 3) -- WIP or RCV
6457: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
6458: -- can be used in case the SQL optimizer uses WLPN as the driving table.
6459: AND wlpn.organization_id = l_organization_id
6460: FOR UPDATE OF mtrl.line_id NOWAIT;
6461:

Line 6486: wms_license_plate_numbers wlpn

6482: p_operation_seq_num NUMBER,
6483: p_repetitive_schedule_id NUMBER) IS
6484: SELECT mtrl.line_id
6485: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
6486: wms_license_plate_numbers wlpn
6487: WHERE mtrl.header_id = mtrh.header_id
6488: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
6489: AND mtrl.organization_id = l_organization_id
6490: AND mtrl.inventory_item_id = l_inventory_item_id

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

6502: AND NVL(mtrl.wms_process_flag, 1) = 1
6503: AND NVL(mtrl.reference, 'non-RMA') <> 'ORDER_LINE_ID'
6504: AND mtrl.lpn_id = wlpn.lpn_id
6505: AND wlpn.lpn_context = p_lpn_context
6506: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
6507: -- can be used in case the SQL optimizer uses WLPN as the driving table.
6508: AND wlpn.organization_id = l_organization_id
6509: AND (p_lpn_context = 3 OR -- RCV
6510: (p_lpn_context = 2 AND -- WIP

Line 6847: wms_license_plate_numbers wlpn

6843: p_demand_source_header_id NUMBER,
6844: p_demand_source_line_id NUMBER) IS
6845: SELECT NVL(SUM(mtrl.primary_quantity), 0)
6846: FROM mtl_txn_request_lines mtrl, wsh_delivery_details wdd,
6847: wms_license_plate_numbers wlpn
6848: WHERE mtrl.organization_id = l_organization_id
6849: AND mtrl.inventory_item_id = l_inventory_item_id
6850: -- Modified the line below to use an IN instead of <> so the
6851: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.

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

6859: -- AND NVL(mtrl.txn_source_line_id, -999) = NVL(p_operation_seq_num, -999)
6860: -- AND NVL(mtrl.reference_id, -999) = NVL(p_repetitive_schedule_id, -999)
6861: AND mtrl.lpn_id = wlpn.lpn_id
6862: AND wlpn.lpn_context = 2 -- WIP
6863: -- Added the following line so the index: WMS_LICENSE_PLATE_NUMBERS_N6
6864: -- can be used in case the SQL optimizer uses WLPN as the driving table.
6865: AND wlpn.organization_id = l_organization_id
6866: AND mtrl.crossdock_type = 1 -- Crossdocked to OE demand
6867: AND mtrl.backorder_delivery_detail_id = wdd.delivery_detail_id