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.RCV_ROI_HEADER dependencies on RCV_SHIPMENT_HEADERS

Line 582: FROM rcv_shipment_headers

578: END IF;
579:
580: SELECT MAX(shipment_header_id) -- if we ever have 2 shipments with the same combo
581: INTO p_header_record.header_record.receipt_header_id
582: FROM rcv_shipment_headers
583: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, NVL(vendor_site_id, -9999))
584: AND vendor_id = p_header_record.header_record.vendor_id
585: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
586: AND shipment_num = p_header_record.header_record.shipment_num

Line 769: FROM rcv_shipment_headers

765: END IF;
766:
767: SELECT MAX(shipment_header_id) -- if we ever have 2 shipments with the same combo
768: INTO p_header_record.header_record.receipt_header_id
769: FROM rcv_shipment_headers
770: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
771: AND vendor_id = p_header_record.header_record.vendor_id
772: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
773: AND shipment_num = p_header_record.header_record.shipment_num

Line 1374: Added the shipped date is null since we are not populating the same in rcv_shipment_headers

1370: * Now this is populated as null since it is supposed to
1371: * be from organization_id. So changed it to ship_to_org_id.
1372: */
1373: /* Bug 2485699- commented the condn trunc(Shipped_date) = trunc(header.record.shipped_date).
1374: Added the shipped date is null since we are not populating the same in rcv_shipment_headers
1375: while receiving thru forms.*/
1376: /* R12 Complex Work.
1377: * Add WC in addition to ASN and ASBN to validate unique
1378: * shipment numbers.

Line 1384: FROM rcv_shipment_headers

1380: IF p_header_record.header_record.asn_type IN('ASN', 'ASBN','WC', 'LCM') /* lcm changes */
1381: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added this for CANCEL
1382: SELECT COUNT(*)
1383: INTO x_count
1384: FROM rcv_shipment_headers
1385: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1386: AND vendor_id = p_header_record.header_record.vendor_id
1387: AND --trunc(shipped_date) = trunc(p_header_record.header_record.shipped_date) and
1388: ( shipped_date IS NULL

Line 1415: FROM rcv_shipment_headers

1411: */
1412: IF p_header_record.header_record.transaction_type = 'REPLACE' THEN
1413: SELECT COUNT(*)
1414: INTO x_count
1415: FROM rcv_shipment_headers
1416: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1417: AND vendor_id = p_header_record.header_record.vendor_id
1418: AND TRUNC(shipped_date) = TRUNC(p_header_record.header_record.shipped_date)
1419: AND shipped_date >= ADD_MONTHS(x_sysdate, -12)

Line 1452: FROM rcv_shipment_headers

1448: IF p_header_record.header_record.transaction_type = 'NEW'
1449: AND p_header_record.header_record.asn_type IN('ASN', 'ASBN', 'LCM') THEN /* lcm changes */
1450: SELECT COUNT(*)
1451: INTO x_count
1452: FROM rcv_shipment_headers
1453: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1454: AND vendor_id = p_header_record.header_record.vendor_id
1455: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1456: AND shipment_num = p_header_record.header_record.shipment_num

Line 1500: FROM rcv_shipment_headers

1496: IF p_header_record.header_record.transaction_type IN('ADD', 'CANCEL')
1497: AND p_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1498: SELECT COUNT(*)
1499: INTO x_count
1500: FROM rcv_shipment_headers
1501: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1502: AND vendor_id = p_header_record.header_record.vendor_id
1503: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1504: AND shipment_num = p_header_record.header_record.shipment_num

Line 1540: FROM rcv_shipment_headers

1536: SELECT SUM(quantity_received)
1537: INTO x_count
1538: FROM rcv_shipment_lines
1539: WHERE EXISTS(SELECT 'x'
1540: FROM rcv_shipment_headers
1541: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1542: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1543: AND vendor_id = p_header_record.header_record.vendor_id
1544: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id

Line 1541: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

1537: INTO x_count
1538: FROM rcv_shipment_lines
1539: WHERE EXISTS(SELECT 'x'
1540: FROM rcv_shipment_headers
1541: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1542: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1543: AND vendor_id = p_header_record.header_record.vendor_id
1544: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1545: AND shipment_num = p_header_record.header_record.shipment_num

Line 1579: FROM rcv_shipment_headers

1575: IF p_header_record.header_record.transaction_type IN('CANCEL')
1576: AND p_header_record.header_record.receipt_header_id IS NULL THEN
1577: SELECT MAX(shipment_header_id)
1578: INTO p_header_record.header_record.receipt_header_id
1579: FROM rcv_shipment_headers
1580: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1581: AND vendor_id = p_header_record.header_record.vendor_id
1582: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1583: AND shipment_num = p_header_record.header_record.shipment_num

Line 1605: FROM rcv_shipment_headers

1601: IF p_header_record.header_record.transaction_type IN('CANCEL')
1602: AND p_header_record.header_record.receipt_header_id IS NOT NULL THEN
1603: SELECT MAX(shipment_header_id)
1604: INTO x_shipment_header_id
1605: FROM rcv_shipment_headers
1606: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1607: AND vendor_id = p_header_record.header_record.vendor_id
1608: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1609: AND shipment_num = p_header_record.header_record.shipment_num

Line 1643: * RCV_SHIPMENT_HEADERS table */

1639: p_header_record.header_record.asn_type := NULL;
1640: END IF;
1641:
1642: /* Bug - 1086088 - Ship_to_org_id needs to get populated in the
1643: * RCV_SHIPMENT_HEADERS table */
1644: IF (g_asn_debug = 'Y') THEN
1645: asn_debug.put_line('Before insert into rsh ');
1646: END IF;
1647:

Line 1648: INSERT INTO rcv_shipment_headers

1644: IF (g_asn_debug = 'Y') THEN
1645: asn_debug.put_line('Before insert into rsh ');
1646: END IF;
1647:
1648: INSERT INTO rcv_shipment_headers
1649: (shipment_header_id,
1650: last_update_date,
1651: last_updated_by,
1652: creation_date,

Line 1842: UPDATE rcv_shipment_headers

1838: asn_debug.put_line('Enter in update_shipment_header ');
1839: asn_debug.put_line(' Shipment_header_id ' || p_header_record.header_record.receipt_header_id);
1840: END IF;
1841:
1842: UPDATE rcv_shipment_headers
1843: SET receipt_num = NVL(receipt_num, p_header_record.header_record.receipt_num),
1844: bill_of_lading = p_header_record.header_record.bill_of_lading,
1845: packing_slip = p_header_record.header_record.packing_slip,
1846: freight_carrier_code = p_header_record.header_record.freight_carrier_code,