APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDORS

Line 1350: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;

1346: l_tp_address VARCHAR2(240);
1347: l_tp_credit_level VARCHAR2(60);
1348:
1349: --For supplier
1350: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;
1351: --For city and address of supplier
1352: TYPE t_sup_city_addr IS RECORD ( city PO_VENDOR_SITES_ALL.CITY%TYPE
1353: ,addr PO_VENDOR_SITES_ALL.ADDRESS_LINE1%TYPE
1354: );

Line 1394: ,PO_VENDORS PV

1390: ,nvl(PV.VENDOR_NAME, '') sup_name
1391: /*,nvl(LC_TYPE.DISPLAYED_FIELD, '') sup_type --vendor_type_disp*/
1392: ,''
1393: FROM JA_CN_ACCOUNT_BALANCES BAL
1394: ,PO_VENDORS PV
1395: /*,PO_LOOKUP_CODES LC_TYPE*/
1396: WHERE BAL.Ledger_Id = l_ledger_id --using variable l_sob_id
1397: AND BAL.account_segment IS NOT NULL
1398: AND BAL.THIRD_PARTY_ID IS NOT NULL