APPS.ZX_VTX_USER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1727: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;

1723: IS
1724:
1725: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;
1726: l_memo_line_id NUMBER;
1727: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1728: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1729:
1730: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_PRODUCT_CODE';
1731:

Line 1764: FROM ra_customer_trx_lines_all

1760: IF arp_product_code_tab(i) IS NULL THEN
1761: BEGIN
1762: SELECT org_id
1763: INTO l_org_id
1764: FROM ra_customer_trx_lines_all
1765: WHERE customer_trx_id = trx_id_tab(i)
1766: AND customer_trx_line_id = trx_line_id_tab(i);
1767: EXCEPTION
1768: WHEN OTHERS THEN

Line 1969: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;

1965: l_sfr_in_out_flag VARCHAR2(1);
1966: l_flag BOOLEAN;
1967: l_inventory_item_id NUMBER;
1968: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1969: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1970: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
1971: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1972:
1973: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';

Line 2057: FROM ra_customer_trx_lines_all

2053: SELECT inventory_item_id
2054: , org_id
2055: INTO l_inventory_item_id
2056: , l_org_id
2057: FROM ra_customer_trx_lines_all
2058: WHERE customer_trx_id = trx_id_tab(i)
2059: AND customer_trx_line_id = trx_line_id_tab(i);
2060: EXCEPTION
2061: WHEN others THEN