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

478: xla_dist.tax_line_ref_id,
479: xla_dist.tax_rec_nrec_dist_ref_id
480: ) ipv_priority
481: -- zx_dtl.tax_type_code
482: FROM zx_rep_trx_detail_t zx_dtl,
483: xla_transaction_entities xla_ent,
484: xla_events xla_event,
485: xla_ae_headers xla_head,
486: xla_ae_lines xla_line,

Line 594: FROM zx_rep_trx_detail_t zx_dtl

590: zx_dtl.tax_status_code,
591: zx_dtl.tax_rate_id,
592: to_number(NULL)
593: -- tax_type_code
594: FROM zx_rep_trx_detail_t zx_dtl
595: WHERE zx_dtl.request_id = c_request_id
596: AND zx_dtl.extract_source_ledger = 'AP'
597: AND ( (nvl(zx_dtl.posted_flag,'N') = 'N')
598: OR

Line 643: UPDATE zx_rep_trx_detail_t

639:
640:
641: IF p_trl_global_variables_rec.reporting_ledger_id IS NOT NULL
642: OR p_trl_global_variables_rec.report_name = 'ZXXTATAT' THEN
643: UPDATE zx_rep_trx_detail_t
644: SET tax_amt = 0,
645: tax_amt_funcl_curr = 0
646: WHERE request_id = G_REQUEST_ID
647: AND extract_source_ledger = 'AP' ;

Line 989: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

985: PROCEDURE extract_party_info( i IN BINARY_INTEGER,
986: P_REPORT_NAME IN VARCHAR2) IS
987:
988:
989: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

Line 990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

986: P_REPORT_NAME IN VARCHAR2) IS
987:
988:
989: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

Line 991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

987:
988:
989: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
995: l_tbl_index_party BINARY_INTEGER;

Line 992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

988:
989: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
995: l_tbl_index_party BINARY_INTEGER;
996: l_tbl_index_site BINARY_INTEGER;

Line 993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;

989: l_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
995: l_tbl_index_party BINARY_INTEGER;
996: l_tbl_index_site BINARY_INTEGER;
997:

Line 994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;

990: l_party_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
991: l_party_profile_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
992: l_site_profile_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
993: l_bill_ship_pty_id zx_rep_trx_detail_t.bill_from_party_id%TYPE;
994: l_bill_ship_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE;
995: l_tbl_index_party BINARY_INTEGER;
996: l_tbl_index_site BINARY_INTEGER;
997:
998: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile

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

995: l_tbl_index_party BINARY_INTEGER;
996: l_tbl_index_site BINARY_INTEGER;
997:
998: -- If party_id is NULL and Historical flag 'N' then get the party ID from zx_party_tax_profile
999: --CURSOR ledger_cur (c_ledger_id ZX_REP_TRX_DETAIL_T.ledger_id%TYPE) IS
1000: -- SELECT name
1001: -- FROM gl_ledgers
1002: -- WHERE ledger_id = c_ledger_id
1003: -- AND rownum = 1;

Line 1006: -- (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS

1002: -- WHERE ledger_id = c_ledger_id
1003: -- AND rownum = 1;
1004:
1005: -- CURSOR party_id_cur
1006: -- (c_bill_from_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE) IS
1007: -- SELECT party_id
1008: -- FROM zx_party_tax_profile
1009: -- WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
1010: -- AND party_type_code = 'THIRD_PARTY';

Line 1013: -- (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS

1009: -- WHERE PARTY_TAX_PROFILE_ID = c_bill_from_ptp_id
1010: -- AND party_type_code = 'THIRD_PARTY';
1011:
1012: -- CURSOR party_site_id_cur
1013: -- (c_bill_from_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE) IS
1014: -- SELECT party_id
1015: -- FROM zx_party_tax_profile
1016: -- WHERE PARTY_TAX_PROFILE_ID = c_bill_from_stp_id
1017: -- AND party_type_code = 'THIRD_PARTY_SITE';

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

1017: -- AND party_type_code = 'THIRD_PARTY_SITE';
1018:
1019: -- If party_id is NOT NULL and Historical flag 'Y' then get the party tax profile ID from zx_party_tax_profile
1020: CURSOR party_reg_num_cur
1021: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
1022: SELECT rep_registration_number
1023: FROM zx_party_tax_profile
1024: WHERE party_id = c_bill_from_party_id
1025: AND party_type_code = 'THIRD_PARTY';

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

1024: WHERE party_id = c_bill_from_party_id
1025: AND party_type_code = 'THIRD_PARTY';
1026:
1027: CURSOR party_site_reg_num_cur
1028: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
1029: SELECT rep_registration_number
1030: FROM zx_party_tax_profile
1031: WHERE party_id = c_bill_from_site_id
1032: AND party_type_code = 'THIRD_PARTY_SITE';

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

1031: WHERE party_id = c_bill_from_site_id
1032: AND party_type_code = 'THIRD_PARTY_SITE';
1033:
1034: CURSOR party_cur
1035: (c_bill_from_party_id zx_rep_trx_detail_t.bill_from_party_id%TYPE) IS
1036: SELECT SEGMENT1,
1037: --VAT_REGISTRATION_NUM,
1038: DECODE(P_REPORT_NAME,'ZXCLPPLR',
1039: NUM_1099||'-'||GLOBAL_ATTRIBUTE12,

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

1045: FROM ap_suppliers
1046: WHERE vendor_id = c_bill_from_party_id;
1047:
1048: CURSOR party_site_cur
1049: (c_bill_from_site_id zx_rep_trx_detail_t.bill_from_party_site_id%TYPE) IS
1050: SELECT CITY,
1051: COUNTY,
1052: STATE,
1053: PROVINCE,

Line 3316: UPDATE /+ INDEX (ZX_REP_TRX_DETAIL_T ZX_REP_TRX_DETAIL_T_U1)/ ZX_REP_TRX_DETAIL_T

3312: 'Rows Update by update_zx_rep_detail_t :'||to_char(p_count));
3313: END IF;
3314:
3315: FORALL i IN 1 .. p_count
3316: UPDATE /*+ INDEX (ZX_REP_TRX_DETAIL_T ZX_REP_TRX_DETAIL_T_U1)*/ ZX_REP_TRX_DETAIL_T
3317: SET REP_CONTEXT_ID = G_REP_CONTEXT_ID,
3318: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
3319: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),
3320: BILLING_TP_TAXPAYER_ID = GT_BILLING_TP_TAXPAYER_ID(i),

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

3375: /*===========================================================================+
3376: | PROCEDURE |
3377: | insert_actg_info |
3378: | DESCRIPTION |
3379: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
3380: | |
3381: | SCOPE - Private |
3382: | |
3383: | NOTES |

Line 3788: UPDATE zx_rep_trx_detail_t zx_dtl

3784: WHEN OTHERS THEN
3785: l_meaning := NULL;
3786: END;
3787:
3788: UPDATE zx_rep_trx_detail_t zx_dtl
3789: SET tax_rate_code_reg_type_mng = l_meaning
3790: ,tax_rate_register_type_code =
3791: DECODE(tax_recoverable_flag,'Y','TAX'
3792: ,'NON-RECOVERABLE')