DBA Data[Home] [Help]

APPS.JA_CN_COA_EXP_PKG dependencies on PO_VENDORS

Line 1351: l_vender_id PO_VENDORS.VENDOR_ID%TYPE;

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

Line 1395: ,PO_VENDORS PV

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