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

Line 98: FROM rcv_shipment_headers

94: x_progress := '040';
95:
96: SELECT ship_to_location_id
97: INTO ship_to_loc_id
98: FROM rcv_shipment_headers
99: WHERE shipment_header_id = x_ship_head_id;
100: END IF;
101:
102: -- Validate ship_to_location_id

Line 690: ** rcv_shipment_headers. If is does, then it returns a value of FALSE. If

686: )
687: RETURN BOOLEAN IS
688: /*
689: ** Function checks if the receipt number passed in already exists in
690: ** rcv_shipment_headers. If is does, then it returns a value of FALSE. If
691: ** it doesn't, then it checks if it exists in po_history_receipts. If it
692: ** does then it returns a value of FALSE. If the receipt number doesn't
693: ** exist in either table, it returns a value of TRUE.
694: */

Line 702: FROM rcv_shipment_headers

698: x_progress := '010';
699:
700: SELECT COUNT(1)
701: INTO dup_count
702: FROM rcv_shipment_headers
703: WHERE receipt_num = x_receipt_num;
704:
705: x_progress := '020';
706:

Line 742: ** rcv_shipment_headers for the current vendor. It returns a value of TRUE

738: )
739: RETURN BOOLEAN IS
740: /*
741: ** Function checks if the shipment number passed in already exists in
742: ** rcv_shipment_headers for the current vendor. It returns a value of TRUE
743: ** if the shipment number passed in is unique, FALSE if it is a duplicate
744: */
745: x_progress VARCHAR2(3) := NULL;
746: dup_count NUMBER := 0;

Line 752: FROM rcv_shipment_headers

748: x_progress := '010';
749:
750: SELECT COUNT(1)
751: INTO dup_count
752: FROM rcv_shipment_headers
753: WHERE shipment_num = x_shipment_num
754: AND receipt_source_code = 'VENDOR'
755: AND vendor_id = x_vendor_id;
756:

Line 1204: 'RCV_SHIPMENT_HEADERS',

1200: x_ret_note_cnt NUMBER;
1201: BEGIN
1202: x_progress := 10;
1203: x_ret_note_cnt := note_info('RVCRC',
1204: 'RCV_SHIPMENT_HEADERS',
1205: 'SHIPMENT_HEADER_ID',
1206: x_header_id
1207: );
1208:

Line 1335: FROM rcv_shipment_headers

1331: AND x_header_record.header_record.receipt_header_id IS NULL THEN
1332: BEGIN
1333: SELECT MAX(shipment_header_id) -- if we ever have 2 shipments with the same combo
1334: INTO x_header_record.header_record.receipt_header_id
1335: FROM rcv_shipment_headers
1336: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1337: AND vendor_id = x_header_record.header_record.vendor_id
1338: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1339: AND shipment_num = x_header_record.header_record.shipment_num

Line 1408: FROM rcv_shipment_headers

1404: AND x_header_record.header_record.receipt_header_id IS NULL THEN
1405: BEGIN
1406: SELECT MAX(shipment_header_id) -- if we ever have 2 shipments with the same combo
1407: INTO x_header_record.header_record.receipt_header_id
1408: FROM rcv_shipment_headers
1409: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1410: AND vendor_id = x_header_record.header_record.vendor_id
1411: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1412: AND shipment_num = x_header_record.header_record.shipment_num

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

1472: * Now this is populated as null since it is supposed to
1473: * be from organization_id. So changed it to ship_to_org_id.
1474: */
1475: /* Bug 2485699- commented the condn trunc(Shipped_date) = trunc(header.record.shipped_date).
1476: Added the shipped date is null since we are not populating the same in rcv_shipment_headers
1477: while receiving thru forms.*/
1478: IF x_header_record.header_record.asn_type IN('ASN', 'ASBN')
1479: AND x_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added this for CANCEL
1480: SELECT COUNT(*)

Line 1482: FROM rcv_shipment_headers

1478: IF x_header_record.header_record.asn_type IN('ASN', 'ASBN')
1479: AND x_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added this for CANCEL
1480: SELECT COUNT(*)
1481: INTO x_count
1482: FROM rcv_shipment_headers
1483: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1484: AND vendor_id = x_header_record.header_record.vendor_id
1485: AND --trunc(shipped_date) = trunc(X_header_record.header_record.shipped_date) and
1486: ( shipped_date IS NULL

Line 1514: FROM rcv_shipment_headers

1510: */
1511: IF x_header_record.header_record.transaction_type = 'REPLACE' THEN
1512: SELECT COUNT(*)
1513: INTO x_count
1514: FROM rcv_shipment_headers
1515: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1516: AND vendor_id = x_header_record.header_record.vendor_id
1517: AND TRUNC(shipped_date) = TRUNC(x_header_record.header_record.shipped_date)
1518: AND shipped_date >= ADD_MONTHS(x_sysdate, -12)

Line 1552: FROM rcv_shipment_headers

1548: IF x_header_record.header_record.transaction_type = 'NEW'
1549: AND x_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1550: SELECT COUNT(*)
1551: INTO x_count
1552: FROM rcv_shipment_headers
1553: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1554: AND vendor_id = x_header_record.header_record.vendor_id
1555: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1556: AND shipment_num = x_header_record.header_record.shipment_num

Line 1600: FROM rcv_shipment_headers

1596: IF x_header_record.header_record.transaction_type IN('ADD', 'CANCEL')
1597: AND x_header_record.header_record.asn_type IN('ASN', 'ASBN') THEN
1598: SELECT COUNT(*)
1599: INTO x_count
1600: FROM rcv_shipment_headers
1601: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1602: AND vendor_id = x_header_record.header_record.vendor_id
1603: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1604: AND shipment_num = x_header_record.header_record.shipment_num

Line 1640: FROM rcv_shipment_headers

1636: SELECT SUM(quantity_received)
1637: INTO x_count
1638: FROM rcv_shipment_lines
1639: WHERE EXISTS(SELECT 'x'
1640: FROM rcv_shipment_headers
1641: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1642: AND NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1643: AND vendor_id = x_header_record.header_record.vendor_id
1644: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id

Line 1641: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

1637: INTO x_count
1638: FROM rcv_shipment_lines
1639: WHERE EXISTS(SELECT 'x'
1640: FROM rcv_shipment_headers
1641: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id
1642: AND NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1643: AND vendor_id = x_header_record.header_record.vendor_id
1644: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1645: AND shipment_num = x_header_record.header_record.shipment_num

Line 1680: FROM rcv_shipment_headers

1676: IF x_header_record.header_record.transaction_type IN('CANCEL')
1677: AND x_header_record.header_record.receipt_header_id IS NULL THEN
1678: SELECT MAX(shipment_header_id)
1679: INTO x_header_record.header_record.receipt_header_id
1680: FROM rcv_shipment_headers
1681: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1682: AND vendor_id = x_header_record.header_record.vendor_id
1683: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1684: AND shipment_num = x_header_record.header_record.shipment_num

Line 1707: FROM rcv_shipment_headers

1703: IF x_header_record.header_record.transaction_type IN('CANCEL')
1704: AND x_header_record.header_record.receipt_header_id IS NOT NULL THEN
1705: SELECT MAX(shipment_header_id)
1706: INTO x_shipment_header_id
1707: FROM rcv_shipment_headers
1708: WHERE NVL(vendor_site_id, -9999) = NVL(x_header_record.header_record.vendor_site_id, -9999)
1709: AND vendor_id = x_header_record.header_record.vendor_id
1710: AND ship_to_org_id = x_header_record.header_record.ship_to_organization_id
1711: AND shipment_num = x_header_record.header_record.shipment_num