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 INV_GLOBALS

Line 2012: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
2015: -- Modified the line below to use an IN instead of <> so the
2016: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.

Line 2017: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

2013: AND mtrl.organization_id = l_organization_id
2014: AND mtrl.inventory_item_id = l_inventory_item_id
2015: -- Modified the line below to use an IN instead of <> so the
2016: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
2017: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
2018: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
2019: inv_globals.g_to_status_approved)
2020: AND mtrl.backorder_delivery_detail_id IS NULL
2021: AND mtrl.lpn_id IS NOT NULL

Line 2018: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,

2014: AND mtrl.inventory_item_id = l_inventory_item_id
2015: -- Modified the line below to use an IN instead of <> so the
2016: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
2017: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
2018: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
2019: inv_globals.g_to_status_approved)
2020: AND mtrl.backorder_delivery_detail_id IS NULL
2021: AND mtrl.lpn_id IS NOT NULL
2022: AND mtrl.quantity > 0

Line 2019: inv_globals.g_to_status_approved)

2015: -- Modified the line below to use an IN instead of <> so the
2016: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
2017: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
2018: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
2019: inv_globals.g_to_status_approved)
2020: AND mtrl.backorder_delivery_detail_id IS NULL
2021: AND mtrl.lpn_id IS NOT NULL
2022: AND mtrl.quantity > 0
2023: AND NVL(mtrl.quantity_delivered, 0) = 0

Line 2326: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
2329: -- Modified the line below to use an IN instead of <> so the
2330: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.

Line 2331: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

2327: AND mtrl.organization_id = l_organization_id
2328: AND mtrl.inventory_item_id = l_inventory_item_id
2329: -- Modified the line below to use an IN instead of <> so the
2330: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
2331: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
2332: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
2333: inv_globals.g_to_status_approved)
2334: AND mtrl.backorder_delivery_detail_id IS NULL
2335: AND mtrl.lpn_id IS NOT NULL

Line 2332: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,

2328: AND mtrl.inventory_item_id = l_inventory_item_id
2329: -- Modified the line below to use an IN instead of <> so the
2330: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
2331: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
2332: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
2333: inv_globals.g_to_status_approved)
2334: AND mtrl.backorder_delivery_detail_id IS NULL
2335: AND mtrl.lpn_id IS NOT NULL
2336: AND mtrl.quantity > 0

Line 2333: inv_globals.g_to_status_approved)

2329: -- Modified the line below to use an IN instead of <> so the
2330: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
2331: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
2332: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
2333: inv_globals.g_to_status_approved)
2334: AND mtrl.backorder_delivery_detail_id IS NULL
2335: AND mtrl.lpn_id IS NOT NULL
2336: AND mtrl.quantity > 0
2337: AND NVL(mtrl.quantity_delivered, 0) = 0

Line 6617: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

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
6618: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
6619: inv_globals.g_to_status_approved)
6620: AND mtrl.backorder_delivery_detail_id IS NULL
6621: AND mtrl.lpn_id IS NOT NULL

Line 6618: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,

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
6618: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
6619: inv_globals.g_to_status_approved)
6620: AND mtrl.backorder_delivery_detail_id IS NULL
6621: AND mtrl.lpn_id IS NOT NULL
6622: AND mtrl.quantity > 0

Line 6619: inv_globals.g_to_status_approved)

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
6618: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
6619: inv_globals.g_to_status_approved)
6620: AND mtrl.backorder_delivery_detail_id IS NULL
6621: AND mtrl.lpn_id IS NOT NULL
6622: AND mtrl.quantity > 0
6623: AND NVL(mtrl.quantity_delivered, 0) = 0

Line 6663: AND mtrh.move_order_type = inv_globals.g_move_order_put_away

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
6666: -- Modified the line below to use an IN instead of <> so the
6667: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.

Line 6668: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

6664: AND mtrl.organization_id = l_organization_id
6665: AND mtrl.inventory_item_id = l_inventory_item_id
6666: -- Modified the line below to use an IN instead of <> so the
6667: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
6668: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
6669: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
6670: inv_globals.g_to_status_approved)
6671: AND mtrl.backorder_delivery_detail_id IS NULL
6672: AND mtrl.lpn_id IS NOT NULL

Line 6669: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,

6665: AND mtrl.inventory_item_id = l_inventory_item_id
6666: -- Modified the line below to use an IN instead of <> so the
6667: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
6668: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
6669: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
6670: inv_globals.g_to_status_approved)
6671: AND mtrl.backorder_delivery_detail_id IS NULL
6672: AND mtrl.lpn_id IS NOT NULL
6673: AND mtrl.quantity > 0

Line 6670: inv_globals.g_to_status_approved)

6666: -- Modified the line below to use an IN instead of <> so the
6667: -- index MTL_TXN_REQUEST_LINES_N10 on MTRL is more likely to be used.
6668: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
6669: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
6670: inv_globals.g_to_status_approved)
6671: AND mtrl.backorder_delivery_detail_id IS NULL
6672: AND mtrl.lpn_id IS NOT NULL
6673: AND mtrl.quantity > 0
6674: AND NVL(mtrl.quantity_delivered, 0) = 0

Line 7027: -- AND mtrl.line_status <> inv_globals.g_to_status_closed

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.
7027: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
7028: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
7029: inv_globals.g_to_status_approved)
7030: AND NVL(mtrl.quantity_delivered, 0) = 0
7031: AND mtrl.txn_source_id = p_wip_entity_id

Line 7028: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,

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.
7027: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
7028: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
7029: inv_globals.g_to_status_approved)
7030: AND NVL(mtrl.quantity_delivered, 0) = 0
7031: AND mtrl.txn_source_id = p_wip_entity_id
7032: -- The two lines below are not required since WIP putaway MOLs do not store

Line 7029: inv_globals.g_to_status_approved)

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.
7027: -- AND mtrl.line_status <> inv_globals.g_to_status_closed
7028: AND mtrl.line_status IN (inv_globals.g_to_status_preapproved,
7029: inv_globals.g_to_status_approved)
7030: AND NVL(mtrl.quantity_delivered, 0) = 0
7031: AND mtrl.txn_source_id = p_wip_entity_id
7032: -- The two lines below are not required since WIP putaway MOLs do not store
7033: -- the operation sequence num or the repetitive schedule ID.