APPS.RCV_RMA_TRANSACTIONS dependencies on RCV_PARAMETERS

Line 1847: /* Bug 3228851 - get the default rma routing from rcv_parameters */

1843: n IN BINARY_INTEGER
1844: ) IS
1845: x_inspection_required_flag VARCHAR2(1);
1846: BEGIN
1847: /* Bug 3228851 - get the default rma routing from rcv_parameters */
1848: SELECT NVL(MIN(inspection_required_flag), 'N')
1849: INTO x_inspection_required_flag
1850: FROM oe_po_enter_receipts_v
1851: WHERE oe_order_header_id = x_cascaded_table(n).oe_order_header_id

Line 1859: FROM rcv_parameters

1855: x_cascaded_table(n).routing_header_id := 2;
1856: ELSIF x_cascaded_table(n).routing_header_id IS NULL THEN
1857: SELECT NVL(MIN(rma_receipt_routing_id), 1)
1858: INTO x_cascaded_table(n).routing_header_id
1859: FROM rcv_parameters
1860: WHERE organization_id = x_cascaded_table(n).to_organization_id;
1861:
1862: IF (g_asn_debug = 'Y') THEN
1863: asn_debug.put_line('Defaulted routing_header_id ' || x_cascaded_table(n).routing_header_id);