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_POPULATE_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 432: FROM zx_rep_trx_detail_t zx_dtl,

428: xla_dist.tax_line_ref_id,
429: xla_dist.tax_rec_nrec_dist_ref_id
430: ) ipv_priority,
431: zx_dtl.tax_type_code
432: FROM zx_rep_trx_detail_t zx_dtl,
433: xla_transaction_entities xla_ent,
434: xla_events xla_event,
435: xla_ae_headers xla_head,
436: xla_ae_lines xla_line,

Line 538: FROM zx_rep_trx_detail_t zx_dtl

534: nvl(zx_dtl.taxable_amt_funcl_curr,zx_dtl.TAXABLE_AMT) ,--Bug 5405785
535: nvl(zx_dtl.tax_amt_funcl_curr,zx_dtl.tax_amt), --Bug 5405785
536: to_number(NULL),
537: tax_type_code
538: FROM zx_rep_trx_detail_t zx_dtl
539: WHERE zx_dtl.request_id = c_request_id
540: AND zx_dtl.extract_source_ledger = 'AP'
541: AND ( (nvl(zx_dtl.posted_flag,'N') = 'N')
542: OR

Line 850: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

846:
847:
848: PROCEDURE extract_party_info( i IN BINARY_INTEGER) IS
849:
850: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

Line 851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

847:
848: PROCEDURE extract_party_info( i IN BINARY_INTEGER) IS
849:
850: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

Line 852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

848: PROCEDURE extract_party_info( i IN BINARY_INTEGER) IS
849:
850: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
856: l_tbl_index_party BINARY_INTEGER;

Line 853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

849:
850: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
856: l_tbl_index_party BINARY_INTEGER;
857: l_tbl_index_site BINARY_INTEGER;

Line 854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

850: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
856: l_tbl_index_party BINARY_INTEGER;
857: l_tbl_index_site BINARY_INTEGER;
858:

Line 855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

851: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
852: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
853: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
854: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
855: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
856: l_tbl_index_party BINARY_INTEGER;
857: l_tbl_index_site BINARY_INTEGER;
858:
859: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile

Line 860: CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS

856: l_tbl_index_party BINARY_INTEGER;
857: l_tbl_index_site BINARY_INTEGER;
858:
859: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile
860: CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS
861: SELECT name
862: FROM gl_ledgers
863: WHERE ledger_id = c_ledger_id
864: AND rownum = 1;

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

863: WHERE ledger_id = c_ledger_id
864: AND rownum = 1;
865:
866: /* CURSOR party_id_cur
867: (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
868: SELECT party_id
869: FROM zx_party_tax_profile
870: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
871: AND party_type_code = 'THIRD_PARTY';

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

870: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
871: AND party_type_code = 'THIRD_PARTY';
872:
873: CURSOR party_site_id_cur
874: (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS
875: SELECT party_id
876: FROM zx_party_tax_profile
877: WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
878: AND party_type_code = 'THIRD_PARTY_SITE';

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

878: AND party_type_code = 'THIRD_PARTY_SITE';
879: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
880: */
881: CURSOR party_reg_num_cur
882: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
883: SELECT rep_registration_number
884: FROM zx_party_tax_profile
885: WHERE party_id = c_bill_from_party_id
886: AND party_type_code = 'THIRD_PARTY';

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

885: WHERE party_id = c_bill_from_party_id
886: AND party_type_code = 'THIRD_PARTY';
887:
888: CURSOR party_site_reg_num_cur
889: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
890: SELECT rep_registration_number
891: FROM zx_party_tax_profile
892: WHERE party_id = c_bill_from_site_id
893: AND party_type_code = 'THIRD_PARTY_SITE';

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

892: WHERE party_id = c_bill_from_site_id
893: AND party_type_code = 'THIRD_PARTY_SITE';
894:
895: CURSOR party_cur
896: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
897: SELECT SEGMENT1,
898: -- VAT_REGISTRATION_NUM,
899: NUM_1099||GLOBAL_ATTRIBUTE12,
900: VENDOR_NAME,

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

904: FROM ap_suppliers
905: WHERE vendor_id = c_bill_from_party_id;
906:
907: CURSOR party_site_cur
908: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
909: SELECT CITY,
910: COUNTY,
911: STATE,
912: PROVINCE,

Line 2783: UPDATE zx_rep_trx_detail_t SET

2779: 'Rows Update by update_zx_rep_detail_t :'||to_char(p_count));
2780: END IF;
2781:
2782: FORALL i IN 1 .. p_count
2783: UPDATE zx_rep_trx_detail_t SET
2784: REP_CONTEXT_ID = G_REP_CONTEXT_ID,
2785: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
2786: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),
2787: BILLING_TP_TAXPAYER_ID = GT_BILLING_TP_TAXPAYER_ID(i),

Line 2845: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|

2841: /*===========================================================================+
2842: | PROCEDURE |
2843: | insert_actg_info |
2844: | DESCRIPTION |
2845: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
2846: | |
2847: | SCOPE - Private |
2848: | |
2849: | NOTES |