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_RCV_DIR_RCPT_APIS dependencies on MTL_SYSTEM_ITEMS

Line 403: , mtl_system_items msi

399: FROM po_headers poh
400: , po_line_locations poll
401: , po_lines pol
402: , po_releases por
403: , mtl_system_items msi
404: , mtl_units_of_measure mum
405: , po_distributions pod
406: WHERE pod.po_distribution_id = v_po_distribution_id
407: AND poh.po_header_id = poll.po_header_id

Line 495: FROM mtl_system_items

491: IF p_item_id IS NOT NULL THEN
492: BEGIN
493: SELECT primary_unit_of_measure
494: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
495: FROM mtl_system_items
496: WHERE mtl_system_items.inventory_item_id = p_item_id
497: AND mtl_system_items.organization_id = p_organization_id;
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN

Line 496: WHERE mtl_system_items.inventory_item_id = p_item_id

492: BEGIN
493: SELECT primary_unit_of_measure
494: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
495: FROM mtl_system_items
496: WHERE mtl_system_items.inventory_item_id = p_item_id
497: AND mtl_system_items.organization_id = p_organization_id;
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: NULL;

Line 497: AND mtl_system_items.organization_id = p_organization_id;

493: SELECT primary_unit_of_measure
494: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
495: FROM mtl_system_items
496: WHERE mtl_system_items.inventory_item_id = p_item_id
497: AND mtl_system_items.organization_id = p_organization_id;
498: EXCEPTION
499: WHEN NO_DATA_FOUND THEN
500: NULL;
501:

Line 1021: , mtl_system_items msi

1017: FROM po_headers poh
1018: , po_line_locations poll
1019: , po_lines pol
1020: , po_releases por
1021: , mtl_system_items msi
1022: , mtl_units_of_measure mum
1023: , po_distributions pod
1024: WHERE pod.po_distribution_id = v_po_distribution_id
1025: AND poh.po_header_id = poll.po_header_id

Line 1131: FROM mtl_system_items

1127: IF p_item_id IS NOT NULL THEN
1128: BEGIN
1129: SELECT primary_unit_of_measure
1130: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1131: FROM mtl_system_items
1132: WHERE mtl_system_items.inventory_item_id = p_item_id
1133: AND mtl_system_items.organization_id = p_organization_id;
1134: EXCEPTION
1135: WHEN NO_DATA_FOUND THEN

Line 1132: WHERE mtl_system_items.inventory_item_id = p_item_id

1128: BEGIN
1129: SELECT primary_unit_of_measure
1130: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1131: FROM mtl_system_items
1132: WHERE mtl_system_items.inventory_item_id = p_item_id
1133: AND mtl_system_items.organization_id = p_organization_id;
1134: EXCEPTION
1135: WHEN NO_DATA_FOUND THEN
1136: NULL;

Line 1133: AND mtl_system_items.organization_id = p_organization_id;

1129: SELECT primary_unit_of_measure
1130: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1131: FROM mtl_system_items
1132: WHERE mtl_system_items.inventory_item_id = p_item_id
1133: AND mtl_system_items.organization_id = p_organization_id;
1134: EXCEPTION
1135: WHEN NO_DATA_FOUND THEN
1136: NULL;
1137:

Line 1766: , mtl_system_items msi

1762: FROM rcv_shipment_headers rsh
1763: , rcv_shipment_lines rsl
1764: , po_requisition_headers porh
1765: , po_requisition_lines porl
1766: , mtl_system_items msi
1767: , mtl_system_items msi1
1768: , mtl_units_of_measure mum
1769: WHERE rsh.receipt_source_code <> 'VENDOR'
1770: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 1767: , mtl_system_items msi1

1763: , rcv_shipment_lines rsl
1764: , po_requisition_headers porh
1765: , po_requisition_lines porl
1766: , mtl_system_items msi
1767: , mtl_system_items msi1
1768: , mtl_units_of_measure mum
1769: WHERE rsh.receipt_source_code <> 'VENDOR'
1770: AND rsl.requisition_line_id = porl.requisition_line_id(+)
1771: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 1970: FROM mtl_system_items

1966:
1967: BEGIN
1968: SELECT primary_unit_of_measure
1969: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1970: FROM mtl_system_items
1971: WHERE mtl_system_items.inventory_item_id = p_item_id
1972: AND mtl_system_items.organization_id = p_organization_id;
1973: EXCEPTION
1974: WHEN NO_DATA_FOUND THEN

Line 1971: WHERE mtl_system_items.inventory_item_id = p_item_id

1967: BEGIN
1968: SELECT primary_unit_of_measure
1969: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1970: FROM mtl_system_items
1971: WHERE mtl_system_items.inventory_item_id = p_item_id
1972: AND mtl_system_items.organization_id = p_organization_id;
1973: EXCEPTION
1974: WHEN NO_DATA_FOUND THEN
1975: IF (l_debug = 1) THEN

Line 1972: AND mtl_system_items.organization_id = p_organization_id;

1968: SELECT primary_unit_of_measure
1969: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1970: FROM mtl_system_items
1971: WHERE mtl_system_items.inventory_item_id = p_item_id
1972: AND mtl_system_items.organization_id = p_organization_id;
1973: EXCEPTION
1974: WHEN NO_DATA_FOUND THEN
1975: IF (l_debug = 1) THEN
1976: print_debug('create_int_shp_dr_del_rti_rec: 3 - get primary_unit_of_measure exception', 4);

Line 2608: , mtl_system_items msi

2604: , NULL secondary_uom_code --OPM Convergence
2605: , NULL secondary_quantity --OPM Convergence
2606: FROM oe_order_lines_all oel
2607: , oe_order_headers_all oeh
2608: , mtl_system_items msi
2609: , mtl_units_of_measure mum
2610: WHERE oel.line_category_code = 'RETURN'
2611: AND oel.header_id = oeh.header_id
2612: AND oel.inventory_item_id = msi.inventory_item_id

Line 2691: FROM mtl_system_items

2687:
2688: BEGIN
2689: SELECT primary_unit_of_measure
2690: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2691: FROM mtl_system_items
2692: WHERE mtl_system_items.inventory_item_id = p_item_id
2693: AND mtl_system_items.organization_id = p_organization_id;
2694: EXCEPTION
2695: WHEN NO_DATA_FOUND THEN

Line 2692: WHERE mtl_system_items.inventory_item_id = p_item_id

2688: BEGIN
2689: SELECT primary_unit_of_measure
2690: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2691: FROM mtl_system_items
2692: WHERE mtl_system_items.inventory_item_id = p_item_id
2693: AND mtl_system_items.organization_id = p_organization_id;
2694: EXCEPTION
2695: WHEN NO_DATA_FOUND THEN
2696: IF (l_debug = 1) THEN

Line 2693: AND mtl_system_items.organization_id = p_organization_id;

2689: SELECT primary_unit_of_measure
2690: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2691: FROM mtl_system_items
2692: WHERE mtl_system_items.inventory_item_id = p_item_id
2693: AND mtl_system_items.organization_id = p_organization_id;
2694: EXCEPTION
2695: WHEN NO_DATA_FOUND THEN
2696: IF (l_debug = 1) THEN
2697: print_debug('create_rma_drct_dlvr_rti_rec: 3 - get primary_unit_of_measure exception', 4);

Line 3256: , mtl_system_items msi

3252: , po_headers poh
3253: , po_line_locations poll
3254: , po_lines pol
3255: , po_releases por
3256: , mtl_system_items msi
3257: , mtl_units_of_measure mum
3258: , po_distributions pod
3259: WHERE pod.po_distribution_id = v_po_distribution_id
3260: AND pod.line_location_id = poll.line_location_id

Line 3419: , mtl_system_items msi

3415: FROM rcv_shipment_headers rsh
3416: , rcv_shipment_lines rsl
3417: , po_requisition_headers porh
3418: , po_requisition_lines porl
3419: , mtl_system_items msi
3420: , mtl_system_items msi1
3421: , mtl_units_of_measure mum
3422: WHERE rsh.receipt_source_code <> 'VENDOR'
3423: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 3420: , mtl_system_items msi1

3416: , rcv_shipment_lines rsl
3417: , po_requisition_headers porh
3418: , po_requisition_lines porl
3419: , mtl_system_items msi
3420: , mtl_system_items msi1
3421: , mtl_units_of_measure mum
3422: WHERE rsh.receipt_source_code <> 'VENDOR'
3423: AND rsl.requisition_line_id = porl.requisition_line_id(+)
3424: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 3577: FROM mtl_system_items

3573:
3574: IF p_item_id IS NOT NULL THEN
3575: SELECT primary_unit_of_measure
3576: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3577: FROM mtl_system_items
3578: WHERE mtl_system_items.inventory_item_id = p_item_id
3579: AND mtl_system_items.organization_id = p_organization_id;
3580:
3581: l_progress := '70';

Line 3578: WHERE mtl_system_items.inventory_item_id = p_item_id

3574: IF p_item_id IS NOT NULL THEN
3575: SELECT primary_unit_of_measure
3576: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3577: FROM mtl_system_items
3578: WHERE mtl_system_items.inventory_item_id = p_item_id
3579: AND mtl_system_items.organization_id = p_organization_id;
3580:
3581: l_progress := '70';
3582: ELSE

Line 3579: AND mtl_system_items.organization_id = p_organization_id;

3575: SELECT primary_unit_of_measure
3576: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3577: FROM mtl_system_items
3578: WHERE mtl_system_items.inventory_item_id = p_item_id
3579: AND mtl_system_items.organization_id = p_organization_id;
3580:
3581: l_progress := '70';
3582: ELSE
3583: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;

Line 4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh

4157: , wlpnc.lot_number
4158: , wlpnc.source_line_id
4159: , wlpn.organization_id lpn_org_id
4160: , wlpnc.secondary_quantity --Bug 7656734
4161: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4162: WHERE rsh.shipment_header_id = p_shipment_header_id
4163: AND (wlpn.source_header_id = rsh.shipment_header_id
4164: OR wlpn.source_name = rsh.shipment_num)
4165: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones