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

Line 216: FROM rcv_shipment_headers

212: IF p_header_record.header_record.receipt_header_id IS NULL THEN
213: BEGIN
214: SELECT MAX(shipment_header_id) -- if we ever have 2 shipments with the same combo
215: INTO p_header_record.header_record.receipt_header_id
216: FROM rcv_shipment_headers
217: WHERE NVL(vendor_site_id, -9999) = NVL(p_header_record.header_record.vendor_site_id, -9999)
218: AND vendor_id = p_header_record.header_record.vendor_id
219: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id
220: AND shipment_num = p_header_record.header_record.shipment_num

Line 322: FROM rcv_shipment_headers rsh

318:
319: IF (x_shipment_header_id IS NULL and x_shipment_num IS NOT NULL) THEN
320: SELECT MAX(rsh.shipment_header_id)
321: INTO x_shipment_header_id
322: FROM rcv_shipment_headers rsh
323: WHERE rsh.shipment_num = x_shipment_num;
324: END IF;
325:
326: IF (x_shipment_header_id IS NOT NULL) THEN

Line 437: FROM rcv_shipment_headers

433:
434: LOOP
435: SELECT COUNT(*)
436: INTO l_count
437: FROM rcv_shipment_headers
438: WHERE receipt_num = p_header_record.header_record.receipt_num
439: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
440:
441: IF l_count = 0 THEN

Line 590: SELECT rcv_shipment_headers_s.NEXTVAL

586: /* generate the shipment_header_id */
587: /* shipment_header_id - receipt_header_id is the same */
588: IF p_header_record.header_record.receipt_header_id IS NULL
589: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
590: SELECT rcv_shipment_headers_s.NEXTVAL
591: INTO p_header_record.header_record.receipt_header_id
592: FROM SYS.DUAL;
593:
594: /* Bug#4523892 */

Line 894: FROM rcv_shipment_headers

890: FROM rcv_shipment_lines
891: WHERE quantity_received > 0
892: AND shipment_header_id IN
893: (SELECT shipment_header_id
894: FROM rcv_shipment_headers
895: WHERE shipment_num = p_header_record.header_record.shipment_num
896: AND ( vendor_site_id =
897: NVL(p_header_record.header_record.vendor_site_id, vendor_site_id)
898: OR vendor_site_id IS NULL)

Line 923: FROM rcv_shipment_headers

919: p_header_record.header_record.receipt_num IS NOT NULL
920: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
921: SELECT COUNT(*)
922: INTO x_count
923: FROM rcv_shipment_headers
924: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
925: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
926: /* Bug 9126513 In case of concurrency issues with multiple RTP sessions running at the same time, multiple
927: RSH records were getting created due to simultaneous execution of the RSH validation above. Now, we

Line 924: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num

920: AND p_header_record.header_record.transaction_type <> 'CANCEL' THEN -- added for support of cancel
921: SELECT COUNT(*)
922: INTO x_count
923: FROM rcv_shipment_headers
924: WHERE rcv_shipment_headers.receipt_num = p_header_record.header_record.receipt_num
925: AND ship_to_org_id = p_header_record.header_record.ship_to_organization_id;
926: /* Bug 9126513 In case of concurrency issues with multiple RTP sessions running at the same time, multiple
927: RSH records were getting created due to simultaneous execution of the RSH validation above. Now, we
928: validate the Receipt Number/(Ship To Organization Id OR Ship To Organization Code) combination in RHI also,

Line 1420: X_rsh_freight_carrier_code rcv_shipment_headers.freight_carrier_code%TYPE := '-999999'; /* Bug 8366230 */

1416: PROCEDURE validate_freight_carrier_info(
1417: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
1418: ) IS
1419:
1420: X_rsh_freight_carrier_code rcv_shipment_headers.freight_carrier_code%TYPE := '-999999'; /* Bug 8366230 */
1421:
1422: BEGIN
1423: /* validate freight carrier information */
1424: /* ASN and ASBN, al transaction_types except CANCEL */

Line 1443: Internal Orders and Inter-org transfers when rcv_shipment_headers.freight_carrier_code is

1439: END IF;
1440:
1441: /*Bug 8366230
1442: Adding IF conditions to ensure that the validation call for freight carriers is not made for
1443: Internal Orders and Inter-org transfers when rcv_shipment_headers.freight_carrier_code is
1444: already populated.
1445: */
1446: BEGIN
1447: IF (p_header_record.header_record.receipt_source_code IN ('INTERNAL ORDER','INVENTORY')) THEN

Line 1450: FROM rcv_shipment_headers rsh

1446: BEGIN
1447: IF (p_header_record.header_record.receipt_source_code IN ('INTERNAL ORDER','INVENTORY')) THEN
1448: SELECT Nvl(rsh.freight_carrier_code,'-999')
1449: INTO X_rsh_freight_carrier_code
1450: FROM rcv_shipment_headers rsh
1451: WHERE rsh.shipment_num = p_header_record.header_record.shipment_num
1452: AND rsh.ship_to_org_id = p_header_record.header_record.ship_to_organization_id
1453: AND rsh.receipt_source_code IN ('INVENTORY','INTERNAL ORDER');
1454: