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 175: FROM zx_rep_trx_detail_t zx_dtl,

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

Line 310: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

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

Line 311: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

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

Line 312: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

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

Line 313: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1577: UPDATE zx_rep_trx_detail_t SET

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