APPS.ZX_VTX_USER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1581: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;

1577: IS
1578:
1579: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;
1580: l_memo_line_id NUMBER;
1581: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1582: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1583:
1584: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_PRODUCT_CODE';
1585:

Line 1618: FROM ra_customer_trx_lines_all

1614: IF arp_product_code_tab(i) IS NULL THEN
1615: BEGIN
1616: SELECT org_id
1617: INTO l_org_id
1618: FROM ra_customer_trx_lines_all
1619: WHERE customer_trx_id = trx_id_tab(i)
1620: AND customer_trx_line_id = trx_line_id_tab(i);
1621: EXCEPTION
1622: WHEN OTHERS THEN

Line 1819: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;

1815: l_sfr_in_out_flag VARCHAR2(1);
1816: l_flag BOOLEAN;
1817: l_inventory_item_id NUMBER;
1818: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1819: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1820: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
1821: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1822:
1823: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';

Line 1907: FROM ra_customer_trx_lines_all

1903: SELECT inventory_item_id
1904: , org_id
1905: INTO l_inventory_item_id
1906: , l_org_id
1907: FROM ra_customer_trx_lines_all
1908: WHERE customer_trx_id = trx_id_tab(i)
1909: AND customer_trx_line_id = trx_line_id_tab(i);
1910: EXCEPTION
1911: WHEN others THEN