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_SV dependencies on STANDARD

Line 147: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

143: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
144: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
145: OR ( NVL(x_include_closed_po, 'N') = 'N'
146: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
147: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
148: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
149: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
150: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'))
151: ORDER BY NVL(pll.promised_date, pll.need_by_date);

Line 180: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

176: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
177: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
178: OR ( NVL(x_include_closed_po, 'N') = 'N'
179: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
180: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
181: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
182: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
183: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
184:

Line 260: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

256: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
257: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
258: OR ( NVL(x_include_closed_po, 'N') = 'N'
259: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
260: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
261: AND pod.distribution_num = NVL(v_distribution_num, pod.distribution_num)
262: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
263: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
264: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'))

Line 307: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')

303: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
304: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
305: OR ( NVL(x_include_closed_po, 'N') = 'N'
306: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
307: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
308: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
309: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
310: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
311:

Line 1773: IF x_shipment_type NOT IN('STANDARD', 'BLANKET', 'SCHEDULED') THEN

1769: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
1770: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
1771: END IF;
1772:
1773: IF x_shipment_type NOT IN('STANDARD', 'BLANKET', 'SCHEDULED') THEN
1774: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1775: rcv_error_pkg.set_error_message('RCV_ASN_INVAL_SHIPMT_TYPE', x_cascaded_table(n).error_message);
1776: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
1777: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);

Line 2570: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');

2566: AND pll.line_location_id = v_line_location_id
2567: AND NVL(pll.approved_flag, 'N') = 'Y'
2568: AND NVL(pll.cancel_flag, 'N') = 'N'
2569: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
2570: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED');
2571:
2572: default_po_info shipments%ROWTYPE;
2573: BEGIN
2574: IF (g_asn_debug = 'Y') THEN

Line 3520: /* 1 is Standard Receipt, 2 is Inspection Required */

3516: IF (g_asn_debug = 'Y') THEN
3517: asn_debug.put_line('Validating routing_header_id');
3518: END IF;
3519:
3520: /* 1 is Standard Receipt, 2 is Inspection Required */
3521: IF ( (x_cascaded_table(n).routing_header_id) IN(1, 2)
3522: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN
3523: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
3524: rcv_error_pkg.set_error_message('RCV_ASN_DELIVER_ROUTING_FAILED', x_cascaded_table(n).error_message);

Line 4295: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED'); -- Could be a quotation with same number

4291: SELECT MAX(po_header_id)
4292: INTO x_po_header_id_record.po_header_id
4293: FROM po_headers
4294: WHERE segment1 = x_po_header_id_record.document_num
4295: AND type_lookup_code IN('STANDARD', 'BLANKET', 'PLANNED'); -- Could be a quotation with same number
4296:
4297: IF (x_po_header_id_record.po_header_id IS NULL) THEN
4298: x_po_header_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
4299: rcv_error_pkg.set_error_message('RCV_ITEM_PO_ID', x_po_header_id_record.error_record.error_message);