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 1764: , mtl_system_items msi

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

Line 1765: , mtl_system_items msi1

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

Line 1893: FROM mtl_system_items

1889:
1890: BEGIN
1891: SELECT primary_unit_of_measure
1892: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1893: FROM mtl_system_items
1894: WHERE mtl_system_items.inventory_item_id = p_item_id
1895: AND mtl_system_items.organization_id = p_organization_id;
1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN

Line 1894: WHERE mtl_system_items.inventory_item_id = p_item_id

1890: BEGIN
1891: SELECT primary_unit_of_measure
1892: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1893: FROM mtl_system_items
1894: WHERE mtl_system_items.inventory_item_id = p_item_id
1895: AND mtl_system_items.organization_id = p_organization_id;
1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN
1898: IF (l_debug = 1) THEN

Line 1895: AND mtl_system_items.organization_id = p_organization_id;

1891: SELECT primary_unit_of_measure
1892: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1893: FROM mtl_system_items
1894: WHERE mtl_system_items.inventory_item_id = p_item_id
1895: AND mtl_system_items.organization_id = p_organization_id;
1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN
1898: IF (l_debug = 1) THEN
1899: print_debug('create_int_shp_dr_del_rti_rec: 3 - get primary_unit_of_measure exception', 4);

Line 2523: , mtl_system_items msi

2519: , NULL secondary_uom_code --OPM Convergence
2520: , NULL secondary_quantity --OPM Convergence
2521: FROM oe_order_lines_all oel
2522: , oe_order_headers_all oeh
2523: , mtl_system_items msi
2524: , mtl_units_of_measure mum
2525: WHERE oel.line_category_code = 'RETURN'
2526: AND oel.header_id = oeh.header_id
2527: AND oel.inventory_item_id = msi.inventory_item_id

Line 2606: FROM mtl_system_items

2602:
2603: BEGIN
2604: SELECT primary_unit_of_measure
2605: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2606: FROM mtl_system_items
2607: WHERE mtl_system_items.inventory_item_id = p_item_id
2608: AND mtl_system_items.organization_id = p_organization_id;
2609: EXCEPTION
2610: WHEN NO_DATA_FOUND THEN

Line 2607: WHERE mtl_system_items.inventory_item_id = p_item_id

2603: BEGIN
2604: SELECT primary_unit_of_measure
2605: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2606: FROM mtl_system_items
2607: WHERE mtl_system_items.inventory_item_id = p_item_id
2608: AND mtl_system_items.organization_id = p_organization_id;
2609: EXCEPTION
2610: WHEN NO_DATA_FOUND THEN
2611: IF (l_debug = 1) THEN

Line 2608: AND mtl_system_items.organization_id = p_organization_id;

2604: SELECT primary_unit_of_measure
2605: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2606: FROM mtl_system_items
2607: WHERE mtl_system_items.inventory_item_id = p_item_id
2608: AND mtl_system_items.organization_id = p_organization_id;
2609: EXCEPTION
2610: WHEN NO_DATA_FOUND THEN
2611: IF (l_debug = 1) THEN
2612: print_debug('create_rma_drct_dlvr_rti_rec: 3 - get primary_unit_of_measure exception', 4);

Line 3152: , mtl_system_items msi

3148: , po_headers poh
3149: , po_line_locations poll
3150: , po_lines pol
3151: , po_releases por
3152: , mtl_system_items msi
3153: , mtl_units_of_measure mum
3154: , po_distributions pod
3155: WHERE pod.po_distribution_id = v_po_distribution_id
3156: AND pod.line_location_id = poll.line_location_id

Line 3315: , mtl_system_items msi

3311: FROM rcv_shipment_headers rsh
3312: , rcv_shipment_lines rsl
3313: , po_requisition_headers porh
3314: , po_requisition_lines porl
3315: , mtl_system_items msi
3316: , mtl_system_items msi1
3317: , mtl_units_of_measure mum
3318: WHERE rsh.receipt_source_code <> 'VENDOR'
3319: AND rsl.requisition_line_id = porl.requisition_line_id(+)

Line 3316: , mtl_system_items msi1

3312: , rcv_shipment_lines rsl
3313: , po_requisition_headers porh
3314: , po_requisition_lines porl
3315: , mtl_system_items msi
3316: , mtl_system_items msi1
3317: , mtl_units_of_measure mum
3318: WHERE rsh.receipt_source_code <> 'VENDOR'
3319: AND rsl.requisition_line_id = porl.requisition_line_id(+)
3320: AND porl.requisition_header_id = porh.requisition_header_id(+)

Line 3473: FROM mtl_system_items

3469:
3470: IF p_item_id IS NOT NULL THEN
3471: SELECT primary_unit_of_measure
3472: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3473: FROM mtl_system_items
3474: WHERE mtl_system_items.inventory_item_id = p_item_id
3475: AND mtl_system_items.organization_id = p_organization_id;
3476:
3477: l_progress := '70';

Line 3474: WHERE mtl_system_items.inventory_item_id = p_item_id

3470: IF p_item_id IS NOT NULL THEN
3471: SELECT primary_unit_of_measure
3472: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3473: FROM mtl_system_items
3474: WHERE mtl_system_items.inventory_item_id = p_item_id
3475: AND mtl_system_items.organization_id = p_organization_id;
3476:
3477: l_progress := '70';
3478: ELSE

Line 3475: AND mtl_system_items.organization_id = p_organization_id;

3471: SELECT primary_unit_of_measure
3472: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3473: FROM mtl_system_items
3474: WHERE mtl_system_items.inventory_item_id = p_item_id
3475: AND mtl_system_items.organization_id = p_organization_id;
3476:
3477: l_progress := '70';
3478: ELSE
3479: 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 4019: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh

4015: , wlpnc.uom_code
4016: , wlpnc.lot_number
4017: , wlpnc.source_line_id
4018: , wlpn.organization_id lpn_org_id
4019: FROM wms_lpn_contents wlpnc, wms_license_plate_numbers wlpn, mtl_system_items msi, rcv_shipment_headers rsh
4020: WHERE rsh.shipment_header_id = p_shipment_header_id
4021: AND (wlpn.source_header_id = rsh.shipment_header_id
4022: OR wlpn.source_name = rsh.shipment_num)
4023: AND wlpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones