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 1202: 'RCV_SHIPMENT_HEADERS',

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

Line 1333: FROM rcv_shipment_headers

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

Line 1406: FROM rcv_shipment_headers

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

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

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

Line 1480: FROM rcv_shipment_headers

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

Line 1512: FROM rcv_shipment_headers

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

Line 1550: FROM rcv_shipment_headers

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

Line 1598: FROM rcv_shipment_headers

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

Line 1638: FROM rcv_shipment_headers

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

Line 1639: WHERE rcv_shipment_headers.shipment_header_id = rcv_shipment_lines.shipment_header_id

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

Line 1678: FROM rcv_shipment_headers

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

Line 1705: FROM rcv_shipment_headers

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