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.

[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_IMPORT_TAX_LINES_GT

Line 166: SELECT count(1) INTO l_count_tax_lines FROM ZX_IMPORT_TAX_LINES_GT;

162: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
163:
164: SELECT count(1) INTO l_count_lines FROM ZX_TRANSACTION_LINES_GT;
165:
166: SELECT count(1) INTO l_count_tax_lines FROM ZX_IMPORT_TAX_LINES_GT;
167:
168: SELECT count(1) INTO l_count_link_gt FROM ZX_TRX_TAX_LINK_GT;
169:
170: IF ( g_level_statement >= g_current_runtime_level) THEN

Line 176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));

172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));
173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));
177: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
178: 'Count of ZX_TRX_TAX_LINK_GT '||to_char(l_count_link_gt));
179: END IF;
180:

Line 303: ZX_IMPORT_TAX_LINES_GT

299: null,
300: interface_entity_code,
301: interface_tax_line_id
302: FROM
303: ZX_IMPORT_TAX_LINES_GT
304: WHERE
305: tax_rate_code IS NULL AND tax_rate_id IS NULL;
306:
307: IF ( g_level_event >= g_current_runtime_level) THEN

Line 540: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

536: /* Default Logic based on Rate Code and Rate Id are seperated
537: to accomodate defaulting when one of them is passed and the other is null.*/
538:
539: -- This Update is to Ensure that the regime and tax get defaulted in case Rate Id is null and Rate Code being passed.
540: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
541: SET (tax_regime_code, tax) =
542: (SELECT NVL(TaxLines.tax_regime_code, qry.tax_regime_code),
543: NVL(TaxLines.tax, qry.tax)
544: FROM (SELECT NVL(rates.tax_regime_code,

Line 553: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,

549: TaxLines_gt.event_class_code event_class_code,
550: TaxLines_gt.trx_id trx_id,
551: TaxLines_gt.summary_tax_line_number summary_tax_line_number
552: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
553: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
554: ZX_TRX_HEADERS_GT Header,
555: ZX_TRANSACTION_LINES_GT Lines,
556: ZX_RATES_B rates,
557: ZX_SUBSCRIPTION_DETAILS sd_rates

Line 657: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

653: AND ROWNUM = 1 -- To Prevent more than one row being fetched for a single row update
654: );
655:
656: -- This Update is to Ensure that the regime and tax get defaulted in case rate code is null and rate id being passed
657: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
658: SET (tax_regime_code, tax) =
659: (SELECT NVL(TaxLines.tax_regime_code, qry.tax_regime_code),
660: NVL(TaxLines.tax, qry.tax)
661: FROM (SELECT NVL(rates.tax_regime_code,

Line 670: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,

666: TaxLines_gt.event_class_code event_class_code,
667: TaxLines_gt.trx_id trx_id,
668: TaxLines_gt.summary_tax_line_number summary_tax_line_number
669: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
670: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
671: ZX_TRX_HEADERS_GT Header,
672: ZX_TRANSACTION_LINES_GT Lines,
673: ZX_RATES_B rates,
674: ZX_SUBSCRIPTION_DETAILS sd_rates

Line 782: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

778: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
779: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Status Code');
780: END IF;
781:
782: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
783: SET tax_status_code =
784: (SELECT Status.tax_status_code
785: FROM ZX_STATUS_B Status,
786: ZX_TRX_HEADERS_GT Header,

Line 918: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for tax_provider_id in ZX_IMPORT_TAX_LINES_GT ');

914:
915: IF (g_level_statement >= g_current_runtime_level ) THEN
916: FND_LOG.STRING(g_level_statement,
917: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
918: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for tax_provider_id in ZX_IMPORT_TAX_LINES_GT ');
919: END IF;
920:
921: --Defaulting for tax Provider Id
922: Update ZX_IMPORT_TAX_LINES_GT TaxLines

Line 922: Update ZX_IMPORT_TAX_LINES_GT TaxLines

918: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for tax_provider_id in ZX_IMPORT_TAX_LINES_GT ');
919: END IF;
920:
921: --Defaulting for tax Provider Id
922: Update ZX_IMPORT_TAX_LINES_GT TaxLines
923: SET tax_provider_id =
924: (SELECT srvc.srvc_provider_id
925: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
926: ZX_REGIMES_USAGES reg,

Line 1011: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

1007: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
1008: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:Defaulting for Tax Jurisdiction Code ');
1009: END IF;
1010:
1011: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1012: SET tax_jurisdiction_code =
1013: (SELECT jur.TAX_JURISDICTION_CODE
1014: FROM ZX_JURISDICTIONS_B Jur,
1015: ZX_TRX_HEADERS_GT Header,

Line 1127: UPDATE zx_import_tax_lines_gt TaxLines

1123:
1124: /* Defaulting for Tax Rate Code, Tax Rate Id, Percentage Rate */
1125: --Bug 4703541 : Seperated Logic to Default Rates and the Jurisdiction Code.
1126: -- bug 7414628 split the query using UNION ALL based on tax_rate_code and tax_rate_id
1127: UPDATE zx_import_tax_lines_gt TaxLines
1128: SET (tax_rate_code,
1129: tax_rate_id,
1130: tax_rate) =
1131: (

Line 1148: zx_import_tax_lines_gt taxlines

1144: FROM zx_rates_b rates,
1145: zx_trx_headers_gt header,
1146: zx_transaction_lines_gt lines,
1147: zx_subscription_details sd_rates,
1148: zx_import_tax_lines_gt taxlines
1149: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)
1150: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1151: AND TaxLines.tax = rates.tax(+)
1152: AND ( TaxLines.tax_jurisdiction_code = rates.tax_jurisdiction_code

Line 1260: zx_import_tax_lines_gt taxlines

1256: FROM zx_rates_b rates,
1257: zx_trx_headers_gt header,
1258: zx_transaction_lines_gt lines,
1259: zx_subscription_details sd_rates,
1260: zx_import_tax_lines_gt taxlines
1261: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)
1262: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1263: AND TaxLines.tax = rates.tax(+)
1264: AND ( TaxLines.tax_jurisdiction_code = rates.tax_jurisdiction_code

Line 1395: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines

1391: END IF;
1392:
1393: --- CR 3275391 Default tax amount if it is NULL and tax rate is specified ----
1394: /* Commented for the Bug 4902521
1395: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1396: SET tax_amt = (SELECT CASE WHEN (tax_amt_included_flag <> 'Y')
1397: THEN tax_rate * line_amt / ( 100 + sum_of_tax_rates)
1398: WHEN (sum_of_tax_rates = 0 )
1399: THEN 0

Line 1413: ZX_IMPORT_TAX_LINES_GT TaxLines,

1409: TaxLink.line_amt,
1410: TaxLines.trx_id,
1411: TaxLines.trx_line_id
1412: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1413: ZX_IMPORT_TAX_LINES_GT TaxLines,
1414: ZX_TRX_HEADERS_GT Header,
1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,

Line 1681: -- zx_import_tax_lines_gt temp_gt,

1677: ZX_TAXES_B tax ,
1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,

Line 1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,

Line 3979: FROM zx_import_tax_lines_gt imptaxes_gt

3975: -- that transaction except the tax-only tax lines
3976: CASE WHEN (lines_gt.ctrl_hdr_tx_appl_flag = 'Y' AND
3977: lines_gt.line_level_action <> 'LINE_INFO_TAX_ONLY' AND
3978: EXISTS (SELECT 1
3979: FROM zx_import_tax_lines_gt imptaxes_gt
3980: WHERE application_id = lines_gt.application_id
3981: AND entity_code = lines_gt.entity_code
3982: AND event_class_code = lines_gt.event_class_code
3983: AND trx_id = lines_gt.trx_id

Line 4011: from zx_import_tax_lines_gt imptaxes_gt

4007: -- that is allocated to all transaction lines (i.e. tax line with allocation flag as 'N').
4008:
4009: CASE WHEN (lines_gt.ctrl_total_line_tx_amt IS NOT NULL AND
4010: exists(select 1
4011: from zx_import_tax_lines_gt imptaxes_gt
4012: where application_id = lines_gt.application_id
4013: AND entity_code = lines_gt.entity_code
4014: AND event_class_code = lines_gt.event_class_code
4015: AND trx_id = lines_gt.trx_id

Line 4026: FROM zx_import_tax_lines_gt imptaxes_gt

4022: -- Tax-only Tax Lines should always have the tax line allocation flag as Y
4023:
4024: CASE WHEN (lines_gt.line_level_action = 'LINE_INFO_TAX_ONLY' AND
4025: EXISTS (SELECT 1
4026: FROM zx_import_tax_lines_gt imptaxes_gt
4027: WHERE application_id = lines_gt.application_id
4028: AND entity_code = lines_gt.entity_code
4029: AND event_class_code = lines_gt.event_class_code
4030: AND trx_id = lines_gt.trx_id

Line 5106: (SELECT /+ INDEX(imptaxes_gt1 ZX_IMPORT_TAX_LINES_GT_U1) /

5102: CASE
5103: WHEN taxlines_gt.tax_regime_code IS NOT NULL AND
5104: taxlines_gt.tax IS NOT NULL AND
5105: EXISTS
5106: (SELECT /*+ INDEX(imptaxes_gt1 ZX_IMPORT_TAX_LINES_GT_U1) */
5107: 1
5108: FROM zx_import_tax_lines_gt imptaxes_gt1
5109: WHERE imptaxes_gt1.application_id= taxlines_gt.application_id
5110: AND imptaxes_gt1.entity_code = taxlines_gt.entity_code

Line 5108: FROM zx_import_tax_lines_gt imptaxes_gt1

5104: taxlines_gt.tax IS NOT NULL AND
5105: EXISTS
5106: (SELECT /*+ INDEX(imptaxes_gt1 ZX_IMPORT_TAX_LINES_GT_U1) */
5107: 1
5108: FROM zx_import_tax_lines_gt imptaxes_gt1
5109: WHERE imptaxes_gt1.application_id= taxlines_gt.application_id
5110: AND imptaxes_gt1.entity_code = taxlines_gt.entity_code
5111: AND imptaxes_gt1.event_class_code = taxlines_gt.event_class_code
5112: AND imptaxes_gt1.trx_id = taxlines_gt.trx_id

Line 5279: FROM zx_import_tax_lines_gt tax_gt

5275: AND zl.tax = taxlines_gt.tax
5276: )
5277: AND NOT EXISTS
5278: (SELECT 1
5279: FROM zx_import_tax_lines_gt tax_gt
5280: WHERE tax_gt.application_id = lines_gt.applied_from_application_id
5281: AND tax_gt.entity_code = lines_gt.applied_from_entity_code
5282: AND tax_gt.event_class_code = lines_gt.applied_from_event_class_code
5283: AND tax_gt.trx_id = lines_gt.applied_from_trx_id

Line 5341: FROM zx_import_tax_lines_gt tax_gt

5337: AND zl.tax = taxlines_gt.tax
5338: )
5339: AND NOT EXISTS
5340: (SELECT 1
5341: FROM zx_import_tax_lines_gt tax_gt
5342: WHERE tax_gt.application_id = lines_gt.adjusted_doc_application_id
5343: AND tax_gt.entity_code = lines_gt.adjusted_doc_entity_code
5344: AND tax_gt.event_class_code = lines_gt.adjusted_doc_event_class_code
5345: AND tax_gt.trx_id = lines_gt.adjusted_doc_trx_id

Line 5401: -- zx_import_tax_lines_gt temp_gt,

5397: ZX_TAXES_B tax ,
5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,

Line 5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,

Line 5770: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

5766: ELSE 'N' END STATUS_SUBSCR_NOT_EFFECTIVE
5767: from
5768: zx_trx_headers_gt header,
5769: zx_transaction_lines_gt lines_gt,
5770: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5771: ZX_REGIMES_B regime ,
5772: ZX_TAXES_B tax ,
5773: ZX_STATUS_B status ,
5774: zx_subscription_details sd_reg,

Line 6164: zx_import_tax_lines_gt temp_gt,

6160: END DEFAULT_RATE_CODE_NOT_EXISTS
6161: FROM ZX_TRX_HEADERS_GT header,
6162: ZX_RATES_B rate ,
6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6166: zx_transaction_lines_gt lines_gt,
6167: zx_subscription_details sd_rates
6168: WHERE taxlines_gt.trx_id = header.trx_id

Line 6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

6161: FROM ZX_TRX_HEADERS_GT header,
6162: ZX_RATES_B rate ,
6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6166: zx_transaction_lines_gt lines_gt,
6167: zx_subscription_details sd_rates
6168: WHERE taxlines_gt.trx_id = header.trx_id
6169: AND taxlines_gt.application_id = Header.application_id

Line 6424: zx_import_tax_lines_gt temp_gt,

6420: ELSE 'Y' END TAX_RATE_NOT_ACTIVE
6421: FROM ZX_TRX_HEADERS_GT header,
6422: ZX_RATES_B rate ,
6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6426: zx_transaction_lines_gt lines_gt,
6427: zx_subscription_details sd_rates
6428: WHERE taxlines_gt.trx_id = header.trx_id

Line 6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

6421: FROM ZX_TRX_HEADERS_GT header,
6422: ZX_RATES_B rate ,
6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6426: zx_transaction_lines_gt lines_gt,
6427: zx_subscription_details sd_rates
6428: WHERE taxlines_gt.trx_id = header.trx_id
6429: AND taxlines_gt.application_id = Header.application_id

Line 6715: FROM zx_import_tax_lines_gt

6711: ELSE NULL
6712: END ZX_INVALID_TRX_LINE_ID,
6713: --Check if the Summary Tax Lines present in Link GTT are also present in Import Tax Lines GTT or not
6714: CASE WHEN NOT EXISTS (SELECT 1
6715: FROM zx_import_tax_lines_gt
6716: WHERE application_id = link_gt.application_id
6717: AND entity_code = link_gt.entity_code
6718: AND event_class_code = link_gt.event_class_code
6719: AND trx_id = link_gt.trx_id