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.INV_UI_ITEM_LOVS dependencies on MTL_CROSS_REFERENCES

Line 151: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' ||

147: -- 1 effectivity control implies that the item is NOT effectivity
148: -- controlled.
149:
150: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
151: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' ||
152: ' WHERE msik.organization_id = ' || p_organization_id ||
153: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
154: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || val ||
155: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

Line 290: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */

286:
287: AND msik.concatenated_segments like :l_conc_seg ' || ' AND msik.organization_id = moqd.organization_id AND msik.inventory_item_id = moqd.inventory_item_id ' || l_where_clause;
288:
289: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
290: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */
291: ' WHERE msik.organization_id = ' || p_organization_id ||
292: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
293: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type ||''''||
294: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

Line 303: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */

299: l_sql_stmt := l_sql_stmt1 || ' from mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code /* Bug 5581528 */
300: || ''' AND msik.concatenated_segments like :l_conc_seg ' || ' AND msik.organization_id = moqd.organization_id AND msik.inventory_item_id = moqd.inventory_item_id ' || l_where_clause;
301:
302: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
303: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */
304: ' WHERE msik.organization_id = ' || p_organization_id ||
305: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
306: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type ||''''||
307: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

Line 311: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */

307: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg
308: , ''%'' ), ' || g_gtin_code_length || ' , ' || '''00000000000000'''||')' ||
309: ' AND (mcr.organization_id = msik.organization_id OR mcr.org_independent_flag = ' || '''Y''' || ')' || l_where_clause;
310: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
311: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */
312: ' WHERE msik.organization_id = ' || p_organization_id ||
313: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
314: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type ||''''||
315: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

Line 452: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */

448: NVL(SECONDARY_DEFAULT_IND,''),
449: NVL(TRACKING_QUANTITY_IND,'P'),
450: NVL(DUAL_UOM_DEVIATION_HIGH,0),
451: NVL(DUAL_UOM_DEVIATION_LOW,0)
452: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
453: WHERE msik.organization_id = p_organization_id
454: AND msik.inventory_item_id = mcr.inventory_item_id
455: AND mcr.cross_reference_type = g_gtin_cross_ref_type
456: AND mcr.cross_reference LIKE l_cross_ref

Line 582: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */

578: NVL(SECONDARY_DEFAULT_IND,''),
579: NVL(TRACKING_QUANTITY_IND,'P'),
580: NVL(DUAL_UOM_DEVIATION_HIGH,0),
581: NVL(DUAL_UOM_DEVIATION_LOW,0)
582: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
583: WHERE msik.organization_id = p_organization_id
584: AND msik.mtl_transactions_enabled_flag = 'Y'
585: AND ((p_transaction_action_id=3 AND EXISTS (SELECT 1
586: FROM mtl_system_items_b msib

Line 942: mtl_cross_references mcr

938: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
939: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
940: FROM mtl_system_items_vl msik, /* Bug 5581528 */
941: mtl_lot_numbers mln,
942: mtl_cross_references mcr
943: WHERE msik.lot_split_enabled = 'Y'
944: AND msik.organization_id = mln.organization_id
945: AND msik.inventory_item_id = mln.inventory_item_id
946: AND mln.lot_number = p_lot_number

Line 1073: mtl_cross_references mcr

1069: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1070: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1071: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1072: mtl_lot_numbers mln,
1073: mtl_cross_references mcr
1074: WHERE msik.lot_merge_enabled = 'Y'
1075: AND msik.organization_id = mln.organization_id
1076: AND msik.inventory_item_id = mln.inventory_item_id
1077: AND mln.lot_number = p_lot_number

Line 1202: mtl_cross_references mcr

1198: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1199: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1200: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1201: mtl_lot_numbers mln,
1202: mtl_cross_references mcr
1203: WHERE msik.organization_id = mln.organization_id
1204: AND msik.inventory_item_id = mln.inventory_item_id
1205: AND mln.lot_number = p_lot_number
1206: AND mln.organization_id = p_organization_id

Line 1319: mtl_cross_references mcr

1315: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1316: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1317: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1318: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1319: mtl_cross_references mcr
1320: WHERE msik.lot_control_code = 2
1321: AND msik.organization_id = p_organization_id
1322: AND msik.inventory_item_id = mcr.inventory_item_id
1323: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 1433: mtl_cross_references mcr

1429: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1430: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1431: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1432: mtl_lot_numbers mln,
1433: mtl_cross_references mcr
1434: WHERE msik.organization_id = mln.organization_id
1435: AND msik.inventory_item_id = mln.inventory_item_id
1436: AND mln.lot_number = p_lot_number
1437: AND mln.organization_id = p_organization_id

Line 2003: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'

1999: || ' AND msik.organization_id = ' || p_organization_id
2000: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'')';
2001:
2002: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
2003: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
2004: || ' WHERE msik.organization_id = ' || p_organization_id
2005: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'' )'
2006: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
2007: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

Line 2152: mtl_cross_references mcr

2148: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2149: wsh_delivery_details dd,
2150: wsh_delivery_assignments da,
2151: wsh_new_deliveries nd,
2152: mtl_cross_references mcr
2153: WHERE msik.organization_id = p_organization_id
2154: AND msik.inventory_item_id = dd.inventory_item_id
2155: AND nd.delivery_id = p_delivery_id
2156: AND nd.delivery_id = da.delivery_id

Line 2313: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */

2309: NVL(SECONDARY_DEFAULT_IND,''),
2310: NVL(TRACKING_QUANTITY_IND,'P'),
2311: NVL(DUAL_UOM_DEVIATION_HIGH,0),
2312: NVL(DUAL_UOM_DEVIATION_LOW,0)
2313: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
2314: WHERE msik.organization_id = p_organization_id
2315: AND msik.inventory_item_id = mcr.inventory_item_id
2316: AND mcr.cross_reference_type = g_gtin_cross_ref_type
2317: AND mcr.cross_reference LIKE l_cross_ref

Line 2442: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit, mtl_cross_references mcr /* Bug 5581528 */

2438: NVL(msik.SECONDARY_DEFAULT_IND,''),
2439: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2440: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2441: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2442: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit, mtl_cross_references mcr /* Bug 5581528 */
2443: WHERE msik.organization_id = p_organization_id
2444: AND msik.inventory_item_id = mpit.inventory_item_id
2445: AND mpit.physical_inventory_id = p_physical_inventory_id
2446: AND mpit.organization_id = p_organization_id

Line 2684: mtl_cross_references mcr

2680: NVL(TRACKING_QUANTITY_IND,'P'),
2681: NVL(DUAL_UOM_DEVIATION_HIGH,0),
2682: NVL(DUAL_UOM_DEVIATION_LOW,0)
2683: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2684: mtl_cross_references mcr
2685: WHERE msik.organization_id = p_organization_id
2686: AND msik.container_item_flag = 'Y'
2687: AND msik.mtl_transactions_enabled_flag = 'Y'
2688: AND msik.inventory_item_id = mcr.inventory_item_id

Line 2867: mtl_cycle_count_items mcci, mtl_cross_references mcr

2863: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2864: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2865: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2866: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2867: mtl_cycle_count_items mcci, mtl_cross_references mcr
2868: WHERE msik.organization_id = p_organization_id
2869: AND msik.inventory_item_id = mcci.inventory_item_id
2870: AND mcci.cycle_count_header_id = p_cycle_count_header_id
2871: AND (msik.serial_number_control_code IN (1, 6)

Line 3003: mtl_cycle_count_entries mcce, mtl_cross_references mcr

2999: NVL(msik.TRACKING_QUANTITY_IND,'P'),
3000: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
3001: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
3002: FROM mtl_system_items_vl msik, /* Bug 5581528 */
3003: mtl_cycle_count_entries mcce, mtl_cross_references mcr
3004: WHERE msik.organization_id = p_organization_id
3005: AND msik.inventory_item_id = mcce.inventory_item_id
3006: AND mcce.cycle_count_header_id = p_cycle_count_header_id
3007: AND mcce.organization_id = p_organization_id

Line 3261: mtl_cross_references mcr

3257: NVL(a.TRACKING_QUANTITY_IND,'P'),
3258: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3259: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3260: FROM mtl_txn_request_lines b, mtl_system_items_vl a, /* Bug 5581528 */
3261: mtl_cross_references mcr
3262: WHERE b.lpn_id = p_lpn_id
3263: AND b.organization_id = p_organization_id
3264: AND b.inspection_status is not null -- 8405606
3265: AND b.organization_id = a.organization_id

Line 3546: mtl_cross_references mcr

3542: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3543: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3544: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3545: mtl_system_items_vl msi, /* Bug 5581528 */
3546: mtl_cross_references mcr
3547: WHERE moq.organization_id = p_org_id
3548: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3549: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))
3550: AND moq.containerized_flag = 2

Line 3665: mtl_cross_references mcr

3661: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3662: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3663: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3664: mtl_system_items_vl msi, /* Bug 5581528 */
3665: mtl_cross_references mcr
3666: WHERE moq.organization_id = p_org_id
3667: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3668: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))
3669: AND NVL(msi.container_item_flag, '@') = NVL(p_container_item_flag, NVL(msi.container_item_flag, '@'))

Line 3790: mtl_cross_references mcr

3786: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3787: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3788: FROM mtl_system_items_vl msi, /* Bug 5581528 */
3789: wms_lpn_contents wlc,
3790: mtl_cross_references mcr
3791: WHERE wlc.organization_id = p_org_id
3792: AND wlc.parent_lpn_id = TO_NUMBER(p_lpn_id)
3793: AND msi.inventory_item_id = wlc.inventory_item_id
3794: AND msi.organization_id = wlc.organization_id

Line 3913: mtl_cross_references mcr

3909: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3910: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3911: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3912: FROM mtl_system_items_vl msi, /* Bug 5581528 */
3913: mtl_cross_references mcr
3914: WHERE msi.organization_id = p_org_id
3915: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)
3916: AND NVL(container_item_flag, 'N') = NVL(p_container_item_flag, NVL(container_item_flag, 'N'))
3917: AND msi.inventory_item_id = mcr.inventory_item_id

Line 4030: mtl_cross_references mcr

4026: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4027: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4028: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
4029: mtl_system_items_vl msi, /* Bug 5581528 */
4030: mtl_cross_references mcr
4031: WHERE msi.organization_id = p_org_id
4032: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)
4033: AND NVL(container_item_flag, 'N') = NVL(p_container_item_flag, NVL(container_item_flag, 'N'))
4034: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)

Line 4147: mtl_cross_references mcr

4143: NVL(TRACKING_QUANTITY_IND,'P'),
4144: NVL(DUAL_UOM_DEVIATION_HIGH,0),
4145: NVL(DUAL_UOM_DEVIATION_LOW,0)
4146: FROM mtl_system_items_vl msik, /* Bug 5581528 */
4147: mtl_cross_references mcr
4148: WHERE msik.organization_id = p_org_id
4149: AND NVL(msik.container_item_flag, 'N') = NVL(p_container_item_flag, NVL(msik.container_item_flag, 'N'))
4150: AND NVL(msik.serial_number_control_code, 1) IN (1, 2, 5, 6)
4151: AND msik.inventory_item_id = mcr.inventory_item_id

Line 4350: mtl_cross_references mcr

4346: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4347: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4348: FROM mtl_system_items_vl a, /* Bug 5581528 */
4349: rcv_transactions_v b,
4350: mtl_cross_references mcr
4351: WHERE b.to_organization_id = p_organization_id
4352: AND b.po_header_id = p_source_id
4353: AND b.inspection_status_code = 'NOT INSPECTED'
4354: AND b.routing_id = 2 /* Inspection routing */

Line 4476: mtl_cross_references mcr

4472: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4473: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4474: FROM mtl_system_items_vl a, /* Bug 5581528 */
4475: rcv_transactions_v b,
4476: mtl_cross_references mcr
4477: WHERE b.to_organization_id = p_organization_id
4478: AND b.shipment_header_id = p_source_id
4479: AND b.receipt_source_code <> 'VENDOR'
4480: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4604: mtl_cross_references mcr

4600: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4601: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4602: FROM mtl_system_items_vl a, /* Bug 5581528 */
4603: rcv_transactions_v b,
4604: mtl_cross_references mcr
4605: WHERE b.to_organization_id = p_organization_id
4606: AND b.oe_order_header_id = p_source_id
4607: AND b.receipt_source_code <> 'VENDOR'
4608: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4737: mtl_cross_references mcr

4733: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4734: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4735: FROM mtl_system_items_vl a, /* Bug 5581528 */
4736: rcv_transactions_v b,
4737: mtl_cross_references mcr
4738: WHERE b.to_organization_id = p_organization_id
4739: AND b.shipment_header_id = TO_CHAR(p_source_id)
4740: AND b.inspection_status_code = 'NOT INSPECTED'
4741: AND b.routing_id = 2 /* Inspection routing */

Line 4872: mtl_cross_references mcr,

4868: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4869: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4870: FROM mtl_system_items_vl a, /* Bug 5581528 */
4871: rcv_transactions_v b,
4872: mtl_cross_references mcr,
4873: (SELECT DISTINCT rsl.shipment_header_id
4874: FROM po_requisition_lines pol,
4875: rcv_shipment_lines rsl
4876: WHERE pol.requisition_header_id = p_source_id

Line 5096: mtl_cross_references mcr

5092: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5093: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5094: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
5095: mtl_system_items_vl msi, /* Bug 5581528 */
5096: mtl_cross_references mcr
5097: WHERE moq.containerized_flag = 2
5098: AND moq.organization_id = p_org_id
5099: AND moq.inventory_item_id = msi.inventory_item_id
5100: AND msi.organization_id = p_org_id

Line 5214: mtl_cross_references mcr

5210: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5211: -- bug 5172851, wms_lpn_contents_v is replaced with
5212: -- wms_lpn_contents for performance reason
5213: wms_lpn_contents wlc,
5214: mtl_cross_references mcr
5215: WHERE msi.inventory_item_id = wlc.inventory_item_id
5216: AND msi.organization_id = p_org_id
5217: AND wlc.parent_lpn_id = p_lpn_id
5218: AND msi.inventory_item_id = mcr.inventory_item_id

Line 5350: mtl_cross_references mcr

5346: NVL(TRACKING_QUANTITY_IND,'P'),
5347: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5348: NVL(DUAL_UOM_DEVIATION_LOW,0)
5349: FROM mtl_system_items_vl msik, /* Bug 5581528 */
5350: mtl_cross_references mcr
5351: WHERE msik.organization_id = p_org_id
5352: AND msik.inventory_item_id = mcr.inventory_item_id
5353: AND mcr.cross_reference_type = g_gtin_cross_ref_type
5354: AND mcr.cross_reference LIKE l_cross_ref

Line 5470: mtl_cross_references mcr

5466: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5467: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5468: FROM mtl_serial_numbers msn,
5469: mtl_system_items_vl msi, /* Bug 5581528 */
5470: mtl_cross_references mcr
5471: WHERE msn.current_organization_id = p_org_id
5472: AND msn.serial_number = p_serial
5473: AND msn.inventory_item_id = msi.inventory_item_id
5474: AND msi.organization_id = msn.current_organization_id

Line 5648: mtl_cross_references mcr

5644: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5645: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5646: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5647: wms_lpn_contents wlpnc,
5648: mtl_cross_references mcr
5649: WHERE wlpnc.parent_lpn_id = p_lpn_id
5650: AND wlpnc.source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5651: AND wlpnc.organization_id = p_org_id
5652: AND msi.organization_id = wlpnc.organization_id

Line 5707: mtl_cross_references mcr

5703: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5704: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5705: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5706: mtl_serial_numbers msn,
5707: mtl_cross_references mcr
5708: WHERE msn.lpn_id = p_lpn_id
5709: AND msn.last_txn_source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5710: AND msn.current_organization_id = p_org_id
5711: AND msi.organization_id = msn.current_organization_id

Line 6041: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'

6037: || ' AND moqd.organization_id = msik.organization_id '
6038: || ' AND moqd.lpn_id is NULL ' ;
6039:
6040: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
6041: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
6042: || ' WHERE msik.organization_id = ' || p_organization_id
6043: || ' AND (msik.serial_number_control_code in (1,6) OR msik.serial_status_enabled = ''Y'' )'
6044: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
6045: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

Line 6079: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'

6075: || ' AND moqd.organization_id = msik.organization_id'
6076: || ' AND moqd.inventory_item_id = msik.inventory_item_id';
6077:
6078: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
6079: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
6080: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
6081: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
6082: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
6083: || ' AND msik.organization_id = ' || p_organization_id