APPS.OZF_OM_VALIDATION_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 1215: FROM ra_customer_trx_all

1211: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1212:
1213: CURSOR csr_order_reference(cv_customer_trx_id IN NUMBER) IS
1214: SELECT interface_header_context
1215: FROM ra_customer_trx_all
1216: WHERE customer_trx_id = cv_customer_trx_id;
1217:
1218: CURSOR csr_ord_total_quantity(cv_header_id IN NUMBER) IS
1219: SELECT ordered_quantity

Line 1234: FROM ra_customer_trx_all

1230: AND line_category_code = 'RETURN';
1231:
1232: CURSOR csr_inv_ord_number(cv_cust_id IN NUMBER) IS
1233: SELECT interface_header_attribute1
1234: FROM ra_customer_trx_all
1235: WHERE customer_trx_id = cv_cust_id;
1236:
1237: CURSOR csr_inv_header_id(cv_customer_trx IN NUMBER) IS
1238: SELECT header_id