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_TRANSACTIONS_INTERFACE_SV1 dependencies on PO_HEADERS

Line 138: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := NULL;

134: x_unit_meas_lookup_code_lines po_lines.unit_meas_lookup_code%TYPE := NULL;
135: x_progress VARCHAR2(3);
136: x_new_conversion NUMBER := 0;
137: x_cum_enabled chv_org_options.enable_cum_flag%TYPE := NULL;
138: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := NULL;
139: -- x_asl_uom chv_cum_period_items.purchasing_unit_of_measure%type := null;
140: x_asl_uom VARCHAR2(80) := NULL;
141: x_primary_unit_of_measure mtl_system_items.primary_unit_of_measure%TYPE := NULL;
142: x_error_status VARCHAR2(1);

Line 235: FROM po_headers

231: WHERE organization_id = NVL(x_uom_record.to_organization_id, organization_id);
232:
233: SELECT NVL(MAX(supply_agreement_flag), 'N')
234: INTO x_supply_agreement_flag
235: FROM po_headers
236: WHERE po_header_id = x_uom_record.po_header_id
237: AND type_lookup_code = 'BLANKET'
238: AND supply_agreement_flag = 'Y';
239:

Line 690: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;

686: PROCEDURE validate_ref_integ(
687: x_ref_integrity_rec IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type,
688: v_header_record IN rcv_shipment_header_sv.headerrectype
689: ) IS
690: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
691: x_po_line_id po_lines.po_line_id%TYPE;
692: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;
693: x_progress VARCHAR2(3);
694: x_error_status VARCHAR2(1);

Line 692: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;

688: v_header_record IN rcv_shipment_header_sv.headerrectype
689: ) IS
690: x_po_vendor_id po_headers.vendor_id%TYPE := NULL;
691: x_po_line_id po_lines.po_line_id%TYPE;
692: x_po_vendor_site_id po_headers.vendor_site_id%TYPE := NULL;
693: x_progress VARCHAR2(3);
694: x_error_status VARCHAR2(1);
695: BEGIN
696: x_error_status := rcv_error_pkg.g_ret_sts_error;

Line 719: FROM po_headers

715:
716: IF x_ref_integrity_rec.vendor_id IS NOT NULL THEN
717: SELECT NVL(MAX(vendor_id), 0)
718: INTO x_po_vendor_id
719: FROM po_headers
720: WHERE po_header_id = x_ref_integrity_rec.po_header_id
721: AND vendor_id = x_ref_integrity_rec.vendor_id;
722:
723: IF (x_po_vendor_id = 0) THEN

Line 741: FROM po_headers

737:
738: IF x_ref_integrity_rec.vendor_site_id IS NOT NULL THEN
739: SELECT NVL(MAX(vendor_site_id), 0)
740: INTO x_po_vendor_site_id
741: FROM po_headers
742: WHERE po_header_id = x_ref_integrity_rec.po_header_id
743: AND vendor_site_id = x_ref_integrity_rec.vendor_site_id;
744:
745: IF (x_po_vendor_site_id = 0) THEN

Line 754: FROM po_headers

750:
751: IF x_ref_integrity_rec.po_revision_num IS NOT NULL THEN
752: SELECT NVL(MAX(vendor_site_id), 0)
753: INTO x_po_vendor_site_id
754: FROM po_headers
755: WHERE po_header_id = x_ref_integrity_rec.po_header_id
756: AND revision_num = x_ref_integrity_rec.po_revision_num;
757:
758: IF (x_po_vendor_site_id = 0) THEN

Line 884: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';

880: ===========================================================================*/
881: PROCEDURE validate_asl(
882: x_asl_record IN OUT NOCOPY rcv_shipment_line_sv.ref_integrity_record_type
883: ) IS
884: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';
885: x_success VARCHAR2(10) := NULL;
886: x_progress VARCHAR2(3);
887: x_error_status VARCHAR2(1);
888: BEGIN

Line 899: FROM po_headers

895: END IF;
896:
897: SELECT NVL(MAX(supply_agreement_flag), 'N')
898: INTO x_supply_agreement_flag
899: FROM po_headers
900: WHERE po_header_id = x_asl_record.po_header_id
901: AND type_lookup_code = 'BLANKET'
902: AND supply_agreement_flag = 'Y';
903:

Line 945: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';

941: ===========================================================================*/
942: PROCEDURE validate_cum_quantity_shipped(
943: x_cum_quantity_record IN OUT NOCOPY rcv_shipment_line_sv.cum_quantity_record_type
944: ) IS
945: x_supply_agreement_flag po_headers.supply_agreement_flag%TYPE := 'Y';
946: x_success VARCHAR2(1) := NULL;
947: x_progress VARCHAR2(3);
948: x_rtv_update_cum_flag chv_org_options.rtv_update_cum_flag%TYPE;
949: x_cum_period_start_date chv_cum_periods.cum_period_start_date%TYPE;

Line 968: FROM po_headers

964: END IF;
965:
966: SELECT NVL(MAX(supply_agreement_flag), 'N')
967: INTO x_supply_agreement_flag
968: FROM po_headers
969: WHERE po_header_id = x_cum_quantity_record.po_header_id
970: AND type_lookup_code = 'BLANKET'
971: AND supply_agreement_flag = 'Y';
972:

Line 1572: l_consumption_po_flag po_headers_all.consigned_consumption_flag%TYPE;

1568: ===========================================================================*/
1569: PROCEDURE validate_consumption_po(
1570: x_consumption_po_rec IN OUT NOCOPY rcv_shipment_line_sv.document_num_record_type
1571: ) IS
1572: l_consumption_po_flag po_headers_all.consigned_consumption_flag%TYPE;
1573: x_error_status VARCHAR2(1);
1574: BEGIN
1575: x_error_status := rcv_error_pkg.g_ret_sts_error;
1576:

Line 1579: FROM po_headers

1575: x_error_status := rcv_error_pkg.g_ret_sts_error;
1576:
1577: SELECT consigned_consumption_flag
1578: INTO l_consumption_po_flag
1579: FROM po_headers
1580: WHERE po_header_id = x_consumption_po_rec.po_header_id;
1581:
1582: IF (l_consumption_po_flag = 'Y') THEN
1583: IF (g_asn_debug = 'Y') THEN