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 584: FROM rcv_shipment_headers

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

Line 771: FROM rcv_shipment_headers

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

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

1344: * Now this is populated as null since it is supposed to
1345: * be from organization_id. So changed it to ship_to_org_id.
1346: */
1347: /* Bug 2485699- commented the condn trunc(Shipped_date) = trunc(header.record.shipped_date).
1348: Added the shipped date is null since we are not populating the same in rcv_shipment_headers
1349: while receiving thru forms.*/
1350: /* R12 Complex Work.
1351: * Add WC in addition to ASN and ASBN to validate unique
1352: * shipment numbers.

Line 1358: FROM rcv_shipment_headers

1354: IF p_header_record.header_record.asn_type IN('ASN', 'ASBN','WC', 'LCM') /* lcm changes */
1355: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added this for CANCEL
1356: SELECT COUNT(*)
1357: INTO x_count
1358: FROM rcv_shipment_headers
1359: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1360: AND vendor_id = p_header_record.header_record.vendor_id
1361: AND --trunc(shipped_date) = trunc(p_header_record.header_record.shipped_date) and
1362: ( shipped_date IS NULL

Line 1389: FROM rcv_shipment_headers

1385: */
1386: IF p_header_record.header_record.transaction_type = 'REPLACE' THEN
1387: SELECT COUNT(*)
1388: INTO x_count
1389: FROM rcv_shipment_headers
1390: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1391: AND vendor_id = p_header_record.header_record.vendor_id
1392: AND TRUNC(shipped_date) = TRUNC(p_header_record.header_record.shipped_date)
1393: AND shipped_date >= ADD_MONTHS(x_sysdate, -12)

Line 1426: FROM rcv_shipment_headers

1422: IF p_header_record.header_record.transaction_type = 'NEW'
1423: AND p_header_record.header_record.asn_type IN('ASN', 'ASBN', 'LCM') THEN /* lcm changes */
1424: SELECT COUNT(*)
1425: INTO x_count
1426: FROM rcv_shipment_headers
1427: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1428: AND vendor_id = p_header_record.header_record.vendor_id
1429: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1430: AND shipment_num = p_header_record.header_record.shipment_num

Line 1474: FROM rcv_shipment_headers

1470: IF p_header_record.header_record.transaction_type IN('ADD', 'CANCEL')
1471: AND p_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1472: SELECT COUNT(*)
1473: INTO x_count
1474: FROM rcv_shipment_headers
1475: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1476: AND vendor_id = p_header_record.header_record.vendor_id
1477: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1478: AND shipment_num = p_header_record.header_record.shipment_num

Line 1514: FROM rcv_shipment_headers

1510: SELECT SUM(quantity_received)
1511: INTO x_count
1512: FROM rcv_shipment_lines
1513: WHERE EXISTS(SELECT 'x'
1514: FROM rcv_shipment_headers
1515: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1516: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1517: AND vendor_id = p_header_record.header_record.vendor_id
1518: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id

Line 1515: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

1511: INTO x_count
1512: FROM rcv_shipment_lines
1513: WHERE EXISTS(SELECT 'x'
1514: FROM rcv_shipment_headers
1515: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1516: AND NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1517: AND vendor_id = p_header_record.header_record.vendor_id
1518: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1519: AND shipment_num = p_header_record.header_record.shipment_num

Line 1553: FROM rcv_shipment_headers

1549: IF p_header_record.header_record.transaction_type IN('CANCEL')
1550: AND p_header_record.header_record.receipt_header_id IS NULL THEN
1551: SELECT MAX(shipment_header_id)
1552: INTO p_header_record.header_record.receipt_header_id
1553: FROM rcv_shipment_headers
1554: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
1555: AND vendor_id = p_header_record.header_record.vendor_id
1556: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1557: 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 NOT NULL THEN
1577: SELECT MAX(shipment_header_id)
1578: INTO x_shipment_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 1617: * RCV_SHIPMENT_HEADERS table */

1613: p_header_record.header_record.asn_type := NULL;
1614: END IF;
1615:
1616: /* Bug - 1086088 - Ship_to_org_id needs to get populated in the
1617: * RCV_SHIPMENT_HEADERS table */
1618: IF (g_asn_debug = 'Y') THEN
1619: asn_debug.put_line('Before insert into rsh ');
1620: END IF;
1621:

Line 1622: INSERT INTO rcv_shipment_headers

1618: IF (g_asn_debug = 'Y') THEN
1619: asn_debug.put_line('Before insert into rsh ');
1620: END IF;
1621:
1622: INSERT INTO rcv_shipment_headers
1623: (shipment_header_id,
1624: last_update_date,
1625: last_updated_by,
1626: creation_date,

Line 1816: UPDATE rcv_shipment_headers

1812: asn_debug.put_line('Enter in update_shipment_header ');
1813: asn_debug.put_line(' Shipment_header_id ' || p_header_record.header_record.receipt_header_id);
1814: END IF;
1815:
1816: UPDATE rcv_shipment_headers
1817: SET receipt_num = NVL(receipt_num, p_header_record.header_record.receipt_num),
1818: bill_of_lading = p_header_record.header_record.bill_of_lading,
1819: packing_slip = p_header_record.header_record.packing_slip,
1820: freight_carrier_code = p_header_record.header_record.freight_carrier_code,