eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AP_ACTG_POPULATE_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 176: FROM zx_rep_trx_detail_t zx_dtl,

172: ZX_ACTG.ACTG_HEADER_ID,
173: ZX_ACTG.ACTG_EVENT_ID,
174: -- ZX_ACTG.ACTG_ENTITY_ID,
175: ZX_ACTG.ACTG_LINE_CCID
176: FROM zx_rep_trx_detail_t zx_dtl,
177: zx_rep_actg_ext_t zx_actg
178: WHERE zx_dtl.request_id = c_request_id
179: AND zx_dtl.extract_source_ledger = 'AP'
180: AND zx_dtl.detail_tax_line_id = zx_actg.detail_tax_line_id;

Line 311: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

307:
308:
309: PROCEDURE extract_party_info( i IN BINARY_INTEGER) IS
310:
311: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
312: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
313: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
314: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
315:

Line 312: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

308:
309: PROCEDURE extract_party_info( i IN BINARY_INTEGER) IS
310:
311: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
312: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
313: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
314: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
315:
316: l_tbl_index_party BINARY_INTEGER;

Line 313: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

309: PROCEDURE extract_party_info( i IN BINARY_INTEGER) IS
310:
311: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
312: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
313: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
314: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
315:
316: l_tbl_index_party BINARY_INTEGER;
317: l_tbl_index_site BINARY_INTEGER;

Line 314: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

310:
311: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
312: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
313: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
314: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
315:
316: l_tbl_index_party BINARY_INTEGER;
317: l_tbl_index_site BINARY_INTEGER;
318:

Line 322: (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS

318:
319: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile
320:
321: CURSOR party_id_cur
322: (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
323: SELECT party_id
324: FROM zx_party_tax_profile
325: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
326: AND party_type_code = 'THIRD_PARTY';

Line 329: (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS

325: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
326: AND party_type_code = 'THIRD_PARTY';
327:
328: CURSOR party_site_id_cur
329: (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS
330: SELECT party_id
331: FROM zx_party_tax_profile
332: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
333: AND party_type_code = 'THIRD_PARTY_SITE';

Line 337: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS

333: AND party_type_code = 'THIRD_PARTY_SITE';
334: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
335:
336: CURSOR party_profile_id_cur
337: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
338: SELECT party_tax_profile_id
339: FROM zx_party_tax_profile
340: WHERE party_id = c_bill_from_party_id
341: AND party_type_code = 'THIRD_PARTY';

Line 344: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS

340: WHERE party_id = c_bill_from_party_id
341: AND party_type_code = 'THIRD_PARTY';
342:
343: CURSOR site_profile_id_cur
344: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
345: SELECT party_tax_profile_id
346: FROM zx_party_tax_profile
347: WHERE party_id = c_bill_from_site_id
348: AND party_type_code = 'THIRD_PARTY_SITE';

Line 351: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS

347: WHERE party_id = c_bill_from_site_id
348: AND party_type_code = 'THIRD_PARTY_SITE';
349:
350: CURSOR party_cur
351: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
352: SELECT SEGMENT1,
353: VAT_REGISTRATION_NUM,
354: NUM_1099,
355: VENDOR_NAME,

Line 362: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS

358: FROM ap_suppliers
359: WHERE party_id = c_bill_from_party_id;
360:
361: CURSOR party_site_cur
362: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
363: SELECT CITY,
364: COUNTY,
365: STATE,
366: PROVINCE,

Line 1580: UPDATE zx_rep_trx_detail_t SET

1576: 'update_zx_rep_detail_t(+)');
1577: END IF;
1578:
1579: FORALL i IN 1 .. p_count
1580: UPDATE zx_rep_trx_detail_t SET
1581: REP_CONTEXT_ID = G_REP_CONTEXT_ID,
1582: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
1583: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),
1584: BILLING_TP_TAXPAYER_ID = GT_BILLING_TP_TAXPAYER_ID(i),