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_STD_RCPT_APIS dependencies on RCV_SHIPMENT_HEADERS

Line 802: SELECT rcv_shipment_headers_s.NEXTVAL

798: g_shipment_header_id := l_rcv_transaction_rec.rcv_shipment_header_id;
799: END IF;
800:
801: IF g_shipment_header_id IS NULL THEN
802: SELECT rcv_shipment_headers_s.NEXTVAL
803: INTO g_shipment_header_id
804: FROM DUAL;
805: END IF;
806:

Line 2703: FROM rcv_shipment_headers rsh

2699: , NULL task_id
2700: , NULL secondary_uom --OPM Convergence
2701: , NULL secondary_uom_code --OPM Convergence
2702: , NULL secondary_quantity --OPM Convergence temp
2703: FROM rcv_shipment_headers rsh
2704: , rcv_shipment_lines rsl
2705: , po_requisition_headers porh
2706: , po_requisition_lines porl
2707: , mtl_system_items msi

Line 2758: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.

2754:
2755: -- query po_startup_value
2756: BEGIN
2757: /* Bug #2516729
2758: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
2759: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
2760: * in order that a new receipt # is not created everytime and the existing receipt # is used
2761: */
2762: BEGIN

Line 2765: FROM rcv_shipment_headers

2761: */
2762: BEGIN
2763: SELECT receipt_num
2764: INTO l_receipt_num
2765: FROM rcv_shipment_headers
2766: WHERE shipment_header_id = p_shipment_header_id
2767: AND ship_to_org_id = p_organization_id;
2768:
2769: --Bug 4252372

Line 2883: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);--bug13558642

2879: INTO l2_lot_code,l_serial_control_code1
2880: FROM mtl_system_items_b
2881: WHERE inventory_item_id = p_item_id
2882: AND ORGANIZATION_id = (SELECT ORGANIZATION_id FROM
2883: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);--bug13558642
2884:
2885: IF (l_debug = 1) THEN
2886: print_debug(' p_shipment_header_id: '||p_shipment_header_id, 4);
2887: print_debug(' l_serial_control_code1: '||l_serial_control_code1, 4);--bug13558642

Line 4100: , rcv_shipment_headers rsh

4096: , NULL secondary_uom --OPM Convergence
4097: , NULL secondary_uom_code --OPM Convergence
4098: , NULL secondary_quantity --OPM Convergence
4099: FROM rcv_shipment_lines rsl
4100: , rcv_shipment_headers rsh
4101: , po_headers poh
4102: , po_line_locations poll
4103: , po_lines pol
4104: , po_releases por

Line 4271: FROM rcv_shipment_headers rsh

4267: , NULL task_id
4268: , NULL secondary_uom --OPM Convergence
4269: , NULL secondary_uom_code --OPM Convergence
4270: , NULL secondary_quantity --OPM Convergence temp
4271: FROM rcv_shipment_headers rsh
4272: , rcv_shipment_lines rsl
4273: , po_requisition_headers porh
4274: , po_requisition_lines porl
4275: , mtl_system_items msi

Line 4331: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.

4327:
4328: -- query po_startup_value
4329: BEGIN
4330: /* Bug #2516729
4331: * Fetch rcv_shipment_headers.receipt_number for the given shipment_header_id.
4332: * If it exists , assign it to the global variable for receipt # (g_rcv_global_var.receipt_num)
4333: * in order that a new receipt # is not created everytime and the existing receipt # is used
4334: */
4335: BEGIN

Line 4338: FROM rcv_shipment_headers

4334: */
4335: BEGIN
4336: SELECT receipt_num
4337: INTO l_receipt_num
4338: FROM rcv_shipment_headers
4339: WHERE shipment_header_id = p_shipment_header_id
4340: AND ship_to_org_id = p_organization_id;
4341:
4342: /* Bug# 6339752 the global variable inv_rcv_common_apis.g_rcv_global_var.receipt_num is to be set only if

Line 4422: from rcv_shipment_headers

4418: and supply_type_code = 'SHIPMENT'
4419: and primary_quantity > 0
4420: and shipment_line_id in
4421: (select shipment_line_id
4422: from rcv_shipment_headers
4423: where shipment_header_id = p_shipment_header_id)
4424: and rownum = 1;
4425: END IF;
4426:

Line 5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh

5114: , lpn.organization_id
5115: , msi.serial_number_control_code
5116: , msi.primary_uom_code
5117: , lpnc.secondary_quantity -- Bug 7708998
5118: FROM wms_lpn_contents lpnc, wms_license_plate_numbers lpn, mtl_system_items_b msi, rcv_shipment_headers rsh
5119: WHERE rsh.shipment_header_id = p_shipment_header_id
5120: AND((lpn.source_header_id = rsh.shipment_header_id)
5121: OR (lpn.source_header_id IS NULL AND lpn.source_name = rsh.shipment_num)) --BUG14846625/16711363
5122: AND lpn.lpn_context IN(6, 7) -- only those pre-ASN receiving ones

Line 5626: wms_license_plate_numbers lpn, rcv_shipment_headers rsh,

5622:
5623: select count(1) into
5624: l_msni_count
5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,
5626: wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
5627: mtl_serial_numbers msn -- Bug 16517269
5628: where rti.interface_transaction_id = msni.product_transaction_id
5629: and rsh.shipment_header_id = p_shipment_header_id
5630: and (lpn.source_header_id = rsh.shipment_header_id

Line 6803: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

6799: BEGIN
6800: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
6801: decode(rsh.asn_type,'ASN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
6802: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
6803: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
6804: WHERE rsl.shipment_line_id = p_shipment_line_id
6805: AND rsl.shipment_header_id = rsh.shipment_header_id;
6806: EXCEPTION
6807: WHEN OTHERS THEN

Line 7451: FROM rcv_shipment_headers

7447: --l_header.expected_receipt_date := Nvl(p_expected_receipt_date,l_sysdate);
7448: IF p_expected_receipt_date IS NULL AND p_shipment_num IS NOT NULL THEN
7449: SELECT expected_receipt_date
7450: INTO l_header.expected_receipt_date
7451: FROM rcv_shipment_headers
7452: WHERE shipment_num = p_shipment_num;
7453: ELSE
7454: l_header.expected_receipt_date := Nvl(p_expected_receipt_date,l_sysdate);
7455: END IF;

Line 7463: FROM rcv_shipment_headers

7459: BEGIN
7460: IF p_expected_receipt_date IS NULL AND p_shipment_num IS NOT NULL AND g_shipment_header_id IS NOT NULL THEN
7461: SELECT Nvl(expected_receipt_date, SYSDATE)
7462: INTO l_header.expected_receipt_date
7463: FROM rcv_shipment_headers
7464: WHERE shipment_num = p_shipment_num
7465: AND shipment_header_id = g_shipment_header_id;
7466: ELSE
7467: l_header.expected_receipt_date := Nvl(p_expected_receipt_date,l_sysdate);

Line 7505: print_debug('rcv_insert_header_interface 20: before rcv_shipment_headers_pkg.insert_row ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

7501: l_header.attribute14 := p_attribute14;
7502: l_header.attribute15 := p_attribute15;
7503:
7504: IF (l_debug = 1) THEN
7505: print_debug('rcv_insert_header_interface 20: before rcv_shipment_headers_pkg.insert_row ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
7506: , 1);
7507: END IF;
7508:
7509: l_progress := '20';

Line 7732: FROM rcv_shipment_headers

7728: --bug9588190,for bug9409867 fix,it is only for ASN receipt,it should be owned by source type='VENDOR' .
7729: if(nvl(l_vendor_site_id,-1)=-1 and p_source_type='VENDOR') then
7730: SELECT vendor_site_id
7731: INTO l_vendor_site_id
7732: FROM rcv_shipment_headers
7733: WHERE shipment_header_id = g_shipment_header_id;
7734: end if;
7735: --bug9409867 end
7736: l_progress := '40';

Line 7833: FROM rcv_shipment_headers

7829: --wms_asn_Details for the item
7830: BEGIN
7831: SELECT NVL(ASN_TYPE,'@@@')
7832: INTO l_check_asn
7833: FROM rcv_shipment_headers
7834: WHERE shipment_header_id = g_shipment_header_id;
7835: EXCEPTION
7836: WHEN OTHERS THEN
7837: IF (l_debug = 1) THEN

Line 8509: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh

8505: , x_msg_data OUT NOCOPY VARCHAR2
8506: ) IS
8507: CURSOR l_curs_remaining_asn IS --modified for bug 4951745
8508: SELECT 1
8509: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8510: WHERE (lpn.source_header_id = rsh.shipment_header_id
8511: OR lpn.source_name = rsh.shipment_num)
8512: AND rsh.shipment_header_id = p_shipment_header_id
8513: AND (p_lpn_id IS NULL OR lpn.lpn_id=p_lpn_id)

Line 8526: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh

8522:
8523: --Added for Bug 4951745
8524: CURSOR l_curs_remaining_asn_has_lpn IS
8525: SELECT 1
8526: FROM wms_lpn_contents_v lpnc, wms_license_plate_numbers lpn, rcv_shipment_headers rsh
8527: WHERE (lpn.source_header_id = rsh.shipment_header_id
8528: OR lpn.source_name = rsh.shipment_num)
8529: AND rsh.shipment_header_id = p_shipment_header_id
8530: AND lpn.lpn_id = p_lpn_id

Line 8701: FROM rcv_shipment_headers

8697: CURSOR l_curs_lpn_for_ship IS
8698: SELECT lpn_id
8699: FROM wms_license_plate_numbers
8700: WHERE source_name = (SELECT shipment_num
8701: FROM rcv_shipment_headers
8702: WHERE shipment_header_id = p_shipment_header_id);
8703:
8704: CURSOR l_curs_lpn_for_asn IS
8705: SELECT lpn_id

Line 8725: FROM rcv_shipment_headers

8721: END IF;
8722:
8723: SELECT SUBSTR(asn_type, 1, 3)
8724: INTO l_asn_type
8725: FROM rcv_shipment_headers
8726: WHERE shipment_header_id = p_shipment_header_id;
8727:
8728: IF (l_debug = 1) THEN
8729: print_debug('clear_LPN_for_ship 10.2 ASN_TYPE =: ' || l_asn_type, 1);

Line 8983: , rcv_shipment_headers rsh

8979: BEGIN
8980: SELECT 1
8981: INTO l_lot_serial_flag
8982: FROM rcv_shipment_lines rsl
8983: , rcv_shipment_headers rsh
8984: , mtl_system_items msi1
8985: , mtl_system_items msi2
8986: WHERE rsh.shipment_num = p_shipment_number
8987: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 9076: , rcv_shipment_headers rsh

9072: BEGIN
9073: SELECT 1
9074: INTO l_lot_serial_flag
9075: FROM rcv_shipment_lines rsl
9076: , rcv_shipment_headers rsh
9077: , mtl_system_items msi1
9078: , mtl_system_items msi2
9079: WHERE rsh.shipment_header_id = p_shipment_header_id
9080: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 9763: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);

9759: INTO l_lot_code
9760: FROM mtl_system_items_b
9761: WHERE inventory_item_id = p_inventory_item_id
9762: AND ORGANIZATION_id = (SELECT ORGANIZATION_id FROM
9763: rcv_shipment_headers WHERE SHIPMENT_HEADER_ID =p_shipment_header_id);
9764: IF (l_debug = 1) THEN
9765: print_debug(' l_lot_code: '|| l_lot_code , 4);
9766: END IF;
9767: