APPS.RCV_RMA_TRANSACTIONS dependencies on RCV_PARAMETERS

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

1848: x_inspection_required_flag VARCHAR2(1);
1849: l_client_code VARCHAR(40); /* Bug 9169143: LSP Changes */
1850:
1851: BEGIN
1852: /* Bug 3228851 - get the default rma routing from rcv_parameters */
1853: SELECT NVL(MIN(inspection_required_flag), 'N')
1854: INTO x_inspection_required_flag
1855: FROM oe_po_enter_receipts_v
1856: WHERE oe_order_header_id = x_cascaded_table(n).oe_order_header_id

Line 1879: FROM rcv_parameters

1875: ELSE
1876:
1877: SELECT NVL(MIN(rma_receipt_routing_id), 1)
1878: INTO x_cascaded_table(n).routing_header_id
1879: FROM rcv_parameters
1880: WHERE organization_id = x_cascaded_table(n).to_organization_id;
1881:
1882: End If;
1883: Else

Line 1887: FROM rcv_parameters

1883: Else
1884:
1885: SELECT NVL(MIN(rma_receipt_routing_id), 1)
1886: INTO x_cascaded_table(n).routing_header_id
1887: FROM rcv_parameters
1888: WHERE organization_id = x_cascaded_table(n).to_organization_id;
1889:
1890: END IF;
1891: