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

Line 475: FROM zx_rep_trx_detail_t

471: BILL_TO_PARTY_SITE_ID,
472: SHIP_TO_PARTY_ID,
473: SHIP_TO_PARTY_SITE_ID,
474: HISTORICAL_FLAG
475: FROM zx_rep_trx_detail_t
476: WHERE EXTRACT_SOURCE_LEDGER = 'AR'
477: AND request_id = c_request_id;
478: */
479:

Line 575: FROM zx_rep_trx_detail_t zx_dtl,

571: zx_dtl.actg_source_id,
572: zx_dtl.bank_account_id,
573: zx_dtl.tax_determine_date,--Bug 5622686
574: zx_dtl.def_rec_settlement_option_code
575: FROM zx_rep_trx_detail_t zx_dtl,
576: xla_transaction_entities xla_ent,
577: xla_events xla_event,
578: xla_ae_headers xla_head,
579: xla_ae_lines xla_line,

Line 710: FROM zx_rep_trx_detail_t zx_dtl

706: ZX_DTL.ACTG_SOURCE_ID,
707: zx_dtl.bank_account_id,
708: ZX_DTL.tax_determine_date, --Bug 5622686
709: ZX_DTL.DEF_REC_SETTLEMENT_OPTION_CODE
710: FROM zx_rep_trx_detail_t zx_dtl
711: WHERE zx_dtl.request_id = c_request_id
712: AND zx_dtl.extract_source_ledger = 'AR'
713: AND (zx_dtl.posted_date IS NULL
714: OR (zx_dtl.posted_date IS NOT NULL AND

Line 823: FROM zx_rep_trx_detail_t zx_dtl,

819: zx_dtl.actg_source_id,
820: zx_dtl.bank_account_id,
821: ZX_DTL.tax_determine_date,
822: ZX_DTL.DEF_REC_SETTLEMENT_OPTION_CODE
823: FROM zx_rep_trx_detail_t zx_dtl,
824: xla_transaction_entities xla_ent,
825: xla_events xla_event,
826: xla_ae_headers xla_head,
827: xla_ae_lines xla_line,

Line 952: FROM zx_rep_trx_detail_t zx_dtl

948: ZX_DTL.ACTG_SOURCE_ID,
949: zx_dtl.bank_account_id,
950: ZX_DTL.tax_determine_date,
951: ZX_DTL.DEF_REC_SETTLEMENT_OPTION_CODE
952: FROM zx_rep_trx_detail_t zx_dtl
953: WHERE zx_dtl.request_id = c_request_id
954: AND zx_dtl.extract_source_ledger = 'AR'
955: AND ((zx_dtl.posted_date IS NULL) OR
956: (zx_dtl.posted_date IS NOT NULL AND zx_dtl.tax_line_id is NULL));

Line 1041: -- records from zx_rep_trx_detail_t for AR discounts that are

1037: l_balancing_segment := substrb(l_balancing_segment,
1038: instrb(l_balancing_segment,'.')+1);
1039:
1040: -- The below DELETE statement is introduced to delete duplicate
1041: -- records from zx_rep_trx_detail_t for AR discounts that are
1042: -- caused due to one tax distribution associated with multiple
1043: -- EDISC lines. TRL dynamic sql query at TRANSACTION level
1044: -- returing duplicate rows in this case.
1045:

Line 1058: UPDATE zx_rep_trx_detail_t DET

1054: WHERE sob.set_of_books_id = p_trl_global_variables_rec.ledger_id
1055: AND cur.currency_code = sob.currency_code;
1056:
1057: IF l_mau is NOT NULL THEN
1058: UPDATE zx_rep_trx_detail_t DET
1059: SET taxable_amt_funcl_curr = ROUND(((SELECT (zl.line_amt * DIST.PERCENT)/100
1060: FROM zx_lines zl,
1061: RA_CUST_TRX_LINE_GL_DIST_ALL DIST
1062: WHERE ZL.TAX_LINE_ID = DET.TAX_LINE_ID

Line 1082: DELETE FROM zx_rep_trx_detail_t dtl1

1078:
1079: IF P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_AR_APPL_TRX_CLASS = 'Y'
1080: OR P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_DISCOUNTS = 'Y' THEN
1081:
1082: DELETE FROM zx_rep_trx_detail_t dtl1
1083: WHERE dtl1.rowid <>( SELECT min(dtl2.rowid)
1084: FROM zx_rep_trx_detail_t dtl2
1085: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1086: AND dtl2.trx_id = dtl1.trx_id

Line 1084: FROM zx_rep_trx_detail_t dtl2

1080: OR P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_DISCOUNTS = 'Y' THEN
1081:
1082: DELETE FROM zx_rep_trx_detail_t dtl1
1083: WHERE dtl1.rowid <>( SELECT min(dtl2.rowid)
1084: FROM zx_rep_trx_detail_t dtl2
1085: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1086: AND dtl2.trx_id = dtl1.trx_id
1087: AND dtl2.tax_line_number = dtl1.tax_line_number
1088: AND dtl2.tax_rate_id = dtl1.tax_rate_id

Line 1111: DELETE FROM zx_rep_trx_detail_t dtl1

1107: END IF;
1108:
1109: -- This query deletes duplicate rows returned by receipts due to 'UNEARN'--
1110: -- OR REVENU line distributed into multiple rows in the ar_distributions_all--
1111: DELETE FROM zx_rep_trx_detail_t dtl1
1112: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id )
1113: FROM zx_rep_trx_detail_t dtl2
1114: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1115: AND dtl2.trx_id = dtl1.trx_id

Line 1113: FROM zx_rep_trx_detail_t dtl2

1109: -- This query deletes duplicate rows returned by receipts due to 'UNEARN'--
1110: -- OR REVENU line distributed into multiple rows in the ar_distributions_all--
1111: DELETE FROM zx_rep_trx_detail_t dtl1
1112: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id )
1113: FROM zx_rep_trx_detail_t dtl2
1114: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1115: AND dtl2.trx_id = dtl1.trx_id
1116: AND NVL(dtl2.tax_line_number,1) = NVL(dtl1.tax_line_number,1)
1117: AND dtl2.tax_rate_id = dtl1.tax_rate_id

Line 1141: DELETE FROM zx_rep_trx_detail_t dtl1

1137:
1138: END IF; --Include check for discounts --
1139:
1140: IF P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE IS NOT NULL THEN
1141: DELETE FROM zx_rep_trx_detail_t dtl1
1142: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id)
1143: FROM zx_rep_trx_detail_t dtl2
1144: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1145: AND dtl2.trx_id = dtl1.trx_id

Line 1143: FROM zx_rep_trx_detail_t dtl2

1139:
1140: IF P_TRL_GLOBAL_VARIABLES_REC.ESL_EU_TRX_TYPE IS NOT NULL THEN
1141: DELETE FROM zx_rep_trx_detail_t dtl1
1142: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id)
1143: FROM zx_rep_trx_detail_t dtl2
1144: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1145: AND dtl2.trx_id = dtl1.trx_id
1146: and dtl2.TAXABLE_ITEM_SOURCE_ID = dtl1.TAXABLE_ITEM_SOURCE_ID
1147: AND dtl2.EVENT_CLASS_CODE = dtl1.EVENT_CLASS_CODE

Line 1157: DELETE FROM zx_rep_trx_detail_t dtl1

1153: AND dtl1.application_id = 222;
1154: END IF;
1155:
1156: IF P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_AR_ADJ_TRX_CLASS = 'Y' THEN
1157: DELETE FROM zx_rep_trx_detail_t dtl1
1158: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id)
1159: FROM zx_rep_trx_detail_t dtl2
1160: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1161: AND dtl2.trx_id = dtl1.trx_id

Line 1159: FROM zx_rep_trx_detail_t dtl2

1155:
1156: IF P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_AR_ADJ_TRX_CLASS = 'Y' THEN
1157: DELETE FROM zx_rep_trx_detail_t dtl1
1158: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id)
1159: FROM zx_rep_trx_detail_t dtl2
1160: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1161: AND dtl2.trx_id = dtl1.trx_id
1162: AND dtl2.tax_line_number = dtl1.tax_line_number
1163: AND dtl2.tax_rate_id = dtl1.tax_rate_id

Line 1186: DELETE FROM zx_rep_trx_detail_t dtl1

1182:
1183: IF (P_TRL_GLOBAL_VARIABLES_REC.SUMMARY_LEVEL = 'TRANSACTION_DISTRIBUTION'
1184: AND P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID is NULL
1185: AND P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_AR_ADJ_TRX_CLASS in ('TAX ADJUSTMENTS','ADJUSTMENTS')) THEN
1186: DELETE FROM zx_rep_trx_detail_t dtl1
1187: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id)
1188: FROM zx_rep_trx_detail_t dtl2
1189: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1190: AND dtl2.trx_id = dtl1.trx_id

Line 1188: FROM zx_rep_trx_detail_t dtl2

1184: AND P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID is NULL
1185: AND P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_AR_ADJ_TRX_CLASS in ('TAX ADJUSTMENTS','ADJUSTMENTS')) THEN
1186: DELETE FROM zx_rep_trx_detail_t dtl1
1187: WHERE trx_line_id <>( SELECT min(dtl2.trx_line_id)
1188: FROM zx_rep_trx_detail_t dtl2
1189: WHERE dtl2.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1190: AND dtl2.trx_id = dtl1.trx_id
1191: AND NVL(dtl2.tax_line_number,0) = NVL(dtl1.tax_line_number,0)
1192: AND NVL(dtl2.tax_rate_id,0) = NVL(dtl1.tax_rate_id,0)

Line 1618: -- Call to update additional information in zx_rep_trx_detail_t table --

1614: END LOOP; -- end loop of each extract line
1615:
1616: END IF;
1617:
1618: -- Call to update additional information in zx_rep_trx_detail_t table --
1619:
1620: UPDATE_REP_DETAIL_T(l_count);
1621:
1622: -- Call to insert accounting information in zx_rep_actg_ext_t table --

Line 3794: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

3790: END convert_amounts;
3791:
3792: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
3793:
3794: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3795: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:

Line 3795: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

3791:
3792: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
3793:
3794: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3795: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

Line 3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

3792: PROCEDURE EXTRACT_PARTY_INFO( i IN BINARY_INTEGER) IS
3793:
3794: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3795: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

Line 3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

3793:
3794: l_bill_to_party_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3795: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

3795: l_bill_to_pty_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3803:

Line 3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

3796: l_bill_to_ptp_id zx_rep_trx_detail_t.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3803:
3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

Line 3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

3797: l_bill_to_stp_id zx_rep_trx_detail_t.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3803:
3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

Line 3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

3798:
3799: l_ship_to_party_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3803:
3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3806:

Line 3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;

3800: l_ship_to_pty_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3803:
3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3806:
3807: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3808: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

Line 3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;

3801: l_ship_to_ptp_id zx_rep_trx_detail_t.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
3802: l_ship_to_stp_id zx_rep_trx_detail_t.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
3803:
3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3806:
3807: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3808: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3809:

Line 3807: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;

3803:
3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3806:
3807: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3808: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3809:
3810: l_bill_ship varchar2(30);
3811:

Line 3808: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;

3804: l_bill_to_acct_id zx_rep_trx_detail_t.BILL_TO_PARTY_ID%TYPE;
3805: l_bill_to_acct_site_id zx_rep_trx_detail_t.BILL_TO_PARTY_SITE_ID%TYPE;
3806:
3807: l_ship_to_acct_id zx_rep_trx_detail_t.SHIP_TO_PARTY_ID%TYPE;
3808: l_ship_to_acct_site_id zx_rep_trx_detail_t.SHIP_TO_PARTY_SITE_ID%TYPE;
3809:
3810: l_bill_ship varchar2(30);
3811:
3812: l_tbl_index_party BINARY_INTEGER;

Line 3843: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS

3839: AND cp_trx_date BETWEEN NVL(REG.EFFECTIVE_FROM,cp_trx_date)
3840: AND NVL(REG.EFFECTIVE_TO,cp_trx_date)
3841: ORDER BY reg.default_registration_flag DESC;
3842:
3843: CURSOR party_cur (c_party_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE) IS
3844: SELECT SUBSTRB(PARTY.PARTY_NAME,1,240) ,
3845: DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.ORGANIZATION_NAME_PHONETIC,NULL),
3846: DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.SIC_CODE,NULL),
3847: PARTY.PARTY_NUMBER,

Line 3852: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS

3848: PARTY.JGZZ_FISCAL_CODE
3849: FROM HZ_PARTIES PARTY
3850: WHERE PARTY.PARTY_ID = c_party_id;
3851:
3852: CURSOR party_site_cur ( c_party_site_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE) IS
3853: SELECT LOC.CITY,
3854: LOC.COUNTY,
3855: LOC.STATE,
3856: LOC.PROVINCE,

Line 3868: CURSOR cust_acct_cur (c_site_use_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,

3864: HZ_LOCATIONS LOC
3865: WHERE party_site.party_site_id = c_party_site_id
3866: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3867:
3868: CURSOR cust_acct_cur (c_site_use_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
3869: c_cust_account_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
3870: c_ship_bill varchar2) IS
3871: SELECT acct.account_number,
3872: acct.global_attribute10,

Line 3869: c_cust_account_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,

3865: WHERE party_site.party_site_id = c_party_site_id
3866: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID;
3867:
3868: CURSOR cust_acct_cur (c_site_use_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_SITE_ID%TYPE,
3869: c_cust_account_id ZX_REP_TRX_DETAIL_T.BILL_TO_PARTY_ID%TYPE,
3870: c_ship_bill varchar2) IS
3871: SELECT acct.account_number,
3872: acct.global_attribute10,
3873: acct.global_attribute12,

Line 3890: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS

3886: and ACCT.CUST_ACCOUNT_ID = c_cust_account_id
3887: and site_use.site_use_code = c_ship_bill;
3888:
3889:
3890: CURSOR bank_tp_taxpayer_cur (c_bank_account_id ZX_REP_TRX_DETAIL_T.BANK_ACCOUNT_ID%TYPE) IS
3891: SELECT NVL(br_party.jgzz_fiscal_code, ba_party.jgzz_fiscal_code)
3892: FROM hz_parties br_party,
3893: hz_parties ba_party,
3894: ce_bank_branches_v ce_branch,

Line 3901: CURSOR doc_seq_name_cur (c_doc_seq_id ZX_REP_TRX_DETAIL_T.doc_seq_id%TYPE) IS

3897: AND ce_accts.bank_branch_id = ce_branch.branch_party_id
3898: AND ce_branch.branch_party_id = br_party.party_id
3899: AND ce_branch.bank_party_id = ba_party.party_id;
3900:
3901: CURSOR doc_seq_name_cur (c_doc_seq_id ZX_REP_TRX_DETAIL_T.doc_seq_id%TYPE) IS
3902: SELECT name
3903: FROM fnd_document_sequences
3904: WHERE doc_sequence_id = c_doc_seq_id;
3905:

Line 4770: CURSOR tax_rate_name_cur (c_tax_rate_id ZX_REP_TRX_DETAIL_T.tax_rate_id%TYPE) IS

4766:
4767: PROCEDURE get_tax_rate_info_dist_adj(i IN BINARY_INTEGER)
4768:
4769: IS
4770: CURSOR tax_rate_name_cur (c_tax_rate_id ZX_REP_TRX_DETAIL_T.tax_rate_id%TYPE) IS
4771: SELECT tax_rate_code,
4772: tax_rate_name,
4773: description,
4774: percentage_rate,

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

4838: 'ZX_AR_POPULATE_PKG: UPDATE_REP_DETAIL_T(+)');
4839: END IF;
4840:
4841: FORALL i in 1..p_count
4842: UPDATE /*+ INDEX (ZX_REP_TRX_DETAIL_T ZX_REP_TRX_DETAIL_T_U1)*/
4843: ZX_REP_TRX_DETAIL_T SET
4844: REP_CONTEXT_ID = G_REP_CONTEXT_ID,
4845: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
4846: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),

Line 4843: ZX_REP_TRX_DETAIL_T SET

4839: END IF;
4840:
4841: FORALL i in 1..p_count
4842: UPDATE /*+ INDEX (ZX_REP_TRX_DETAIL_T ZX_REP_TRX_DETAIL_T_U1)*/
4843: ZX_REP_TRX_DETAIL_T SET
4844: REP_CONTEXT_ID = G_REP_CONTEXT_ID,
4845: BILLING_TP_NUMBER = GT_BILLING_TP_NUMBER(i),
4846: BILLING_TP_TAX_REG_NUM = GT_BILLING_TP_TAX_REG_NUM(i),
4847: BILLING_TP_SITE_TAX_REG_NUM = GT_BILLING_SITE_TAX_REG_NUM(i),

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

4953: /*===========================================================================+
4954: | PROCEDURE |
4955: | insert_actg_info |
4956: | DESCRIPTION |
4957: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
4958: | |
4959: | SCOPE - Private |
4960: | |
4961: | NOTES |