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 143: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' ||

139: -- 1 effectivity control implies that the item is NOT effectivity
140: -- controlled.
141:
142: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
143: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' ||
144: ' WHERE msik.organization_id = ' || p_organization_id ||
145: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
146: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || val ||
147: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

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

254: || ''' AND moqd.locator_id = ' || p_locator_id ||
255: ' 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;
256:
257: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
258: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */
259: ' WHERE msik.organization_id = ' || p_organization_id ||
260: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
261: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type ||''''||
262: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

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

267: 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 */
268: || ''' 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;
269:
270: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
271: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */
272: ' WHERE msik.organization_id = ' || p_organization_id ||
273: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
274: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type ||''''||
275: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

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

275: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg
276: , ''%'' ), ' || g_gtin_code_length || ' , ' || '''00000000000000'''||')' ||
277: ' AND (mcr.organization_id = msik.organization_id OR mcr.org_independent_flag = ' || '''Y''' || ')' || l_where_clause;
278: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
279: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */
280: ' WHERE msik.organization_id = ' || p_organization_id ||
281: ' AND msik.inventory_item_id = mcr.inventory_item_id ' ||
282: ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type ||''''||
283: ' AND mcr.cross_reference like lpad(rtrim(:l_conc_seg

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

407: NVL(SECONDARY_DEFAULT_IND,''),
408: NVL(TRACKING_QUANTITY_IND,'P'),
409: NVL(DUAL_UOM_DEVIATION_HIGH,0),
410: NVL(DUAL_UOM_DEVIATION_LOW,0)
411: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
412: WHERE msik.organization_id = p_organization_id
413: AND msik.inventory_item_id = mcr.inventory_item_id
414: AND mcr.cross_reference_type = g_gtin_cross_ref_type
415: AND mcr.cross_reference LIKE l_cross_ref

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

531: NVL(SECONDARY_DEFAULT_IND,''),
532: NVL(TRACKING_QUANTITY_IND,'P'),
533: NVL(DUAL_UOM_DEVIATION_HIGH,0),
534: NVL(DUAL_UOM_DEVIATION_LOW,0)
535: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
536: WHERE msik.organization_id = p_organization_id
537: AND msik.mtl_transactions_enabled_flag = 'Y'
538: AND ((p_transaction_action_id=3 AND EXISTS (SELECT 1
539: FROM mtl_system_items_b msib

Line 833: mtl_cross_references mcr

829: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
830: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
831: FROM mtl_system_items_vl msik, /* Bug 5581528 */
832: mtl_lot_numbers mln,
833: mtl_cross_references mcr
834: WHERE msik.lot_split_enabled = 'Y'
835: AND msik.organization_id = mln.organization_id
836: AND msik.inventory_item_id = mln.inventory_item_id
837: AND mln.lot_number = p_lot_number

Line 962: mtl_cross_references mcr

958: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
959: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
960: FROM mtl_system_items_vl msik, /* Bug 5581528 */
961: mtl_lot_numbers mln,
962: mtl_cross_references mcr
963: WHERE msik.lot_merge_enabled = 'Y'
964: AND msik.organization_id = mln.organization_id
965: AND msik.inventory_item_id = mln.inventory_item_id
966: AND mln.lot_number = p_lot_number

Line 1089: mtl_cross_references mcr

1085: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1086: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1087: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1088: mtl_lot_numbers mln,
1089: mtl_cross_references mcr
1090: WHERE msik.organization_id = mln.organization_id
1091: AND msik.inventory_item_id = mln.inventory_item_id
1092: AND mln.lot_number = p_lot_number
1093: AND mln.organization_id = p_organization_id

Line 1204: mtl_cross_references mcr

1200: NVL(msik.TRACKING_QUANTITY_IND,'P'),
1201: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1202: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1203: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1204: mtl_cross_references mcr
1205: WHERE msik.lot_control_code = 2
1206: AND msik.organization_id = p_organization_id
1207: AND msik.inventory_item_id = mcr.inventory_item_id
1208: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 1316: mtl_cross_references mcr

1312: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
1313: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
1314: FROM mtl_system_items_vl msik, /* Bug 5581528 */
1315: mtl_lot_numbers mln,
1316: mtl_cross_references mcr
1317: WHERE msik.organization_id = mln.organization_id
1318: AND msik.inventory_item_id = mln.inventory_item_id
1319: AND mln.lot_number = p_lot_number
1320: AND mln.organization_id = p_organization_id

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

1877: || ' AND msik.organization_id = ' || p_organization_id
1878: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'')';
1879:
1880: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
1881: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
1882: || ' WHERE msik.organization_id = ' || p_organization_id
1883: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'' )'
1884: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
1885: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

Line 2024: mtl_cross_references mcr

2020: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2021: wsh_delivery_details dd,
2022: wsh_delivery_assignments da,
2023: wsh_new_deliveries nd,
2024: mtl_cross_references mcr
2025: WHERE msik.organization_id = p_organization_id
2026: AND msik.inventory_item_id = dd.inventory_item_id
2027: AND nd.delivery_id = p_delivery_id
2028: AND nd.delivery_id = da.delivery_id

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

2172: NVL(SECONDARY_DEFAULT_IND,''),
2173: NVL(TRACKING_QUANTITY_IND,'P'),
2174: NVL(DUAL_UOM_DEVIATION_HIGH,0),
2175: NVL(DUAL_UOM_DEVIATION_LOW,0)
2176: FROM mtl_system_items_vl msik, mtl_cross_references mcr /* Bug 5581528 */
2177: WHERE msik.organization_id = p_organization_id
2178: AND msik.inventory_item_id = mcr.inventory_item_id
2179: AND mcr.cross_reference_type = g_gtin_cross_ref_type
2180: AND mcr.cross_reference LIKE l_cross_ref

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

2297: NVL(msik.SECONDARY_DEFAULT_IND,''),
2298: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2299: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2300: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2301: FROM mtl_system_items_vl msik, mtl_physical_inventory_tags mpit, mtl_cross_references mcr /* Bug 5581528 */
2302: WHERE msik.organization_id = p_organization_id
2303: AND msik.inventory_item_id = mpit.inventory_item_id
2304: AND mpit.physical_inventory_id = p_physical_inventory_id
2305: AND mpit.organization_id = p_organization_id

Line 2539: mtl_cross_references mcr

2535: NVL(TRACKING_QUANTITY_IND,'P'),
2536: NVL(DUAL_UOM_DEVIATION_HIGH,0),
2537: NVL(DUAL_UOM_DEVIATION_LOW,0)
2538: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2539: mtl_cross_references mcr
2540: WHERE msik.organization_id = p_organization_id
2541: AND msik.container_item_flag = 'Y'
2542: AND msik.mtl_transactions_enabled_flag = 'Y'
2543: AND msik.inventory_item_id = mcr.inventory_item_id

Line 2714: mtl_cycle_count_items mcci, mtl_cross_references mcr

2710: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2711: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2712: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2713: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2714: mtl_cycle_count_items mcci, mtl_cross_references mcr
2715: WHERE msik.organization_id = p_organization_id
2716: AND msik.inventory_item_id = mcci.inventory_item_id
2717: AND mcci.cycle_count_header_id = p_cycle_count_header_id
2718: AND (msik.serial_number_control_code IN (1, 6)

Line 2848: mtl_cycle_count_entries mcce, mtl_cross_references mcr

2844: NVL(msik.TRACKING_QUANTITY_IND,'P'),
2845: NVL(msik.DUAL_UOM_DEVIATION_HIGH,0),
2846: NVL(msik.DUAL_UOM_DEVIATION_LOW,0)
2847: FROM mtl_system_items_vl msik, /* Bug 5581528 */
2848: mtl_cycle_count_entries mcce, mtl_cross_references mcr
2849: WHERE msik.organization_id = p_organization_id
2850: AND msik.inventory_item_id = mcce.inventory_item_id
2851: AND mcce.cycle_count_header_id = p_cycle_count_header_id
2852: AND mcce.organization_id = p_organization_id

Line 3100: mtl_cross_references mcr

3096: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
3097: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
3098: FROM mtl_system_items_vl a, /* Bug 5581528 */
3099: mtl_txn_request_lines b,
3100: mtl_cross_references mcr
3101: WHERE b.lpn_id = p_lpn_id
3102: AND b.organization_id = p_organization_id
3103: AND b.inspection_status = 1 /* Yet to be inspected */
3104: AND b.organization_id = a.organization_id

Line 3315: mtl_cross_references mcr

3311: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3312: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3313: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3314: mtl_system_items_vl msi, /* Bug 5581528 */
3315: mtl_cross_references mcr
3316: WHERE moq.organization_id = p_org_id
3317: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3318: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))
3319: AND moq.containerized_flag = 2

Line 3432: mtl_cross_references mcr

3428: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3429: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3430: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3431: mtl_system_items_vl msi, /* Bug 5581528 */
3432: mtl_cross_references mcr
3433: WHERE moq.organization_id = p_org_id
3434: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3435: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))
3436: AND NVL(msi.container_item_flag, '@') = NVL(p_container_item_flag, NVL(msi.container_item_flag, '@'))

Line 3552: mtl_cross_references mcr

3548: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3549: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3550: FROM mtl_system_items_vl msi, /* Bug 5581528 */
3551: wms_lpn_contents wlc,
3552: mtl_cross_references mcr
3553: WHERE wlc.organization_id = p_org_id
3554: AND wlc.parent_lpn_id = TO_NUMBER(p_lpn_id)
3555: AND msi.inventory_item_id = wlc.inventory_item_id
3556: AND msi.organization_id = wlc.organization_id

Line 3670: mtl_cross_references mcr

3666: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3667: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3668: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3669: FROM mtl_system_items_vl msi, /* Bug 5581528 */
3670: mtl_cross_references mcr
3671: WHERE msi.organization_id = p_org_id
3672: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)
3673: AND NVL(container_item_flag, 'N') = NVL(p_container_item_flag, NVL(container_item_flag, 'N'))
3674: AND msi.inventory_item_id = mcr.inventory_item_id

Line 3785: mtl_cross_references mcr

3781: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3782: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3783: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3784: mtl_system_items_vl msi, /* Bug 5581528 */
3785: mtl_cross_references mcr
3786: WHERE msi.organization_id = p_org_id
3787: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)
3788: AND NVL(container_item_flag, 'N') = NVL(p_container_item_flag, NVL(container_item_flag, 'N'))
3789: AND moq.subinventory_code = NVL(p_subinventory_code, moq.subinventory_code)

Line 3900: mtl_cross_references mcr

3896: NVL(TRACKING_QUANTITY_IND,'P'),
3897: NVL(DUAL_UOM_DEVIATION_HIGH,0),
3898: NVL(DUAL_UOM_DEVIATION_LOW,0)
3899: FROM mtl_system_items_vl msik, /* Bug 5581528 */
3900: mtl_cross_references mcr
3901: WHERE msik.organization_id = p_org_id
3902: AND NVL(msik.container_item_flag, 'N') = NVL(p_container_item_flag, NVL(msik.container_item_flag, 'N'))
3903: AND NVL(msik.serial_number_control_code, 1) IN (1, 2, 5, 6)
3904: AND msik.inventory_item_id = mcr.inventory_item_id

Line 4091: mtl_cross_references mcr

4087: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4088: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4089: FROM mtl_system_items_vl a, /* Bug 5581528 */
4090: rcv_transactions_v b,
4091: mtl_cross_references mcr
4092: WHERE b.to_organization_id = p_organization_id
4093: AND b.po_header_id = p_source_id
4094: AND b.inspection_status_code = 'NOT INSPECTED'
4095: AND b.routing_id = 2 /* Inspection routing */

Line 4215: mtl_cross_references mcr

4211: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4212: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4213: FROM mtl_system_items_vl a, /* Bug 5581528 */
4214: rcv_transactions_v b,
4215: mtl_cross_references mcr
4216: WHERE b.to_organization_id = p_organization_id
4217: AND b.shipment_header_id = p_source_id
4218: AND b.receipt_source_code <> 'VENDOR'
4219: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4341: mtl_cross_references mcr

4337: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4338: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4339: FROM mtl_system_items_vl a, /* Bug 5581528 */
4340: rcv_transactions_v b,
4341: mtl_cross_references mcr
4342: WHERE b.to_organization_id = p_organization_id
4343: AND b.oe_order_header_id = p_source_id
4344: AND b.receipt_source_code <> 'VENDOR'
4345: AND b.inspection_status_code = 'NOT INSPECTED'

Line 4466: mtl_cross_references mcr

4462: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4463: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4464: FROM mtl_system_items_vl a, /* Bug 5581528 */
4465: rcv_transactions_v b,
4466: mtl_cross_references mcr
4467: WHERE b.to_organization_id = p_organization_id
4468: AND b.shipment_header_id = TO_CHAR(p_source_id)
4469: AND b.inspection_status_code = 'NOT INSPECTED'
4470: AND b.routing_id = 2 /* Inspection routing */

Line 4599: mtl_cross_references mcr,

4595: NVL(a.DUAL_UOM_DEVIATION_HIGH,0),
4596: NVL(a.DUAL_UOM_DEVIATION_LOW,0)
4597: FROM mtl_system_items_vl a, /* Bug 5581528 */
4598: rcv_transactions_v b,
4599: mtl_cross_references mcr,
4600: (SELECT DISTINCT rsl.shipment_header_id
4601: FROM po_requisition_lines pol,
4602: rcv_shipment_lines rsl
4603: WHERE pol.requisition_header_id = p_source_id

Line 4817: mtl_cross_references mcr

4813: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4814: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4815: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
4816: mtl_system_items_vl msi, /* Bug 5581528 */
4817: mtl_cross_references mcr
4818: WHERE moq.containerized_flag = 2
4819: AND moq.organization_id = p_org_id
4820: AND moq.inventory_item_id = msi.inventory_item_id
4821: AND msi.organization_id = p_org_id

Line 4933: mtl_cross_references mcr

4929: FROM mtl_system_items_vl msi, /* Bug 5581528 */
4930: -- bug 5172851, wms_lpn_contents_v is replaced with
4931: -- wms_lpn_contents for performance reason
4932: wms_lpn_contents wlc,
4933: mtl_cross_references mcr
4934: WHERE msi.inventory_item_id = wlc.inventory_item_id
4935: AND msi.organization_id = p_org_id
4936: AND wlc.parent_lpn_id = p_lpn_id
4937: AND msi.inventory_item_id = mcr.inventory_item_id

Line 5063: mtl_cross_references mcr

5059: NVL(TRACKING_QUANTITY_IND,'P'),
5060: NVL(DUAL_UOM_DEVIATION_HIGH,0),
5061: NVL(DUAL_UOM_DEVIATION_LOW,0)
5062: FROM mtl_system_items_vl msik, /* Bug 5581528 */
5063: mtl_cross_references mcr
5064: WHERE msik.organization_id = p_org_id
5065: AND msik.inventory_item_id = mcr.inventory_item_id
5066: AND mcr.cross_reference_type = g_gtin_cross_ref_type
5067: AND mcr.cross_reference LIKE l_cross_ref

Line 5177: mtl_cross_references mcr

5173: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5174: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5175: FROM mtl_serial_numbers msn,
5176: mtl_system_items_vl msi, /* Bug 5581528 */
5177: mtl_cross_references mcr
5178: WHERE msn.current_organization_id = p_org_id
5179: AND msn.serial_number = p_serial
5180: AND msn.inventory_item_id = msi.inventory_item_id
5181: AND msi.organization_id = msn.current_organization_id

Line 5348: mtl_cross_references mcr

5344: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5345: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5346: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5347: wms_lpn_contents wlpnc,
5348: mtl_cross_references mcr
5349: WHERE wlpnc.parent_lpn_id = p_lpn_id
5350: AND wlpnc.source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5351: AND wlpnc.organization_id = p_org_id
5352: AND msi.organization_id = wlpnc.organization_id

Line 5406: mtl_cross_references mcr

5402: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5403: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5404: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5405: mtl_serial_numbers msn,
5406: mtl_cross_references mcr
5407: WHERE msn.lpn_id = p_lpn_id
5408: AND msn.last_txn_source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5409: AND msn.current_organization_id = p_org_id
5410: AND msi.organization_id = msn.current_organization_id

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

5703: || ' AND moqd.organization_id = msik.organization_id '
5704: || ' AND moqd.lpn_id is NULL ' ;
5705:
5706: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
5707: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
5708: || ' WHERE msik.organization_id = ' || p_organization_id
5709: || ' AND (msik.serial_number_control_code in (1,6) OR msik.serial_status_enabled = ''Y'' )'
5710: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
5711: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

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

5741: || ' AND moqd.organization_id = msik.organization_id'
5742: || ' AND moqd.inventory_item_id = msik.inventory_item_id';
5743:
5744: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
5745: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
5746: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
5747: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
5748: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
5749: || ' AND msik.organization_id = ' || p_organization_id