DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 206: FROM zx_rep_trx_detail_t dtl

202: dtl.last_updated_by,
203: dtl.last_update_date,
204: dtl.last_update_login,
205: p_request_id
206: FROM zx_rep_trx_detail_t dtl
207: WHERE EXISTS (select distinct ah.invoice_id
208: FROM ap_holds_all ah
209: WHERE ah.invoice_id = dtl.trx_id
210: AND ah.release_lookup_code IS NULL )

Line 234: zx_rep_trx_detail_t dtl,

230: l_trx_currency_desc_tbl,
231: l_batch_name_tbl,
232: l_acc_ccid_tbl
233: FROM
234: zx_rep_trx_detail_t dtl,
235: fnd_currencies_vl fcv,
236: ap_invoices_all ai,
237: ap_batches_all ab,
238: zx_rates_b rates,

Line 336: zx_rep_trx_detail_t dtl

332: zx_reporting_codes_b rep_code,
333: zx_report_codes_assoc rep_ass,
334: zx_party_tax_profile ptp,
335: xle_etb_profiles xle_pf ,
336: zx_rep_trx_detail_t dtl
337: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
338: AND rep_type.reporting_type_code = 'MEMBER STATE'
339: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
340: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

Line 379: --Bug 5251425 : To derive the C_CREATED_BY(zx_rep_trx_detail_t.attribute6)

375: 'After getting the org_vat_num' );
376: END IF;
377:
378:
379: --Bug 5251425 : To derive the C_CREATED_BY(zx_rep_trx_detail_t.attribute6)
380: -- and C_ATTRIBUTE3(Operating Unit Desc) into (zx_rep_trx_detail_t.attribute7)
381:
382: GET_CREATED_BY(
383: l_detail_tax_line_id_tbl,

Line 380: -- and C_ATTRIBUTE3(Operating Unit Desc) into (zx_rep_trx_detail_t.attribute7)

376: END IF;
377:
378:
379: --Bug 5251425 : To derive the C_CREATED_BY(zx_rep_trx_detail_t.attribute6)
380: -- and C_ATTRIBUTE3(Operating Unit Desc) into (zx_rep_trx_detail_t.attribute7)
381:
382: GET_CREATED_BY(
383: l_detail_tax_line_id_tbl,
384: l_trx_id_tbl,

Line 441: DELETE FROM zx_rep_trx_detail_t itf

437: END IF;
438:
439: -- Delete Unwanted lines from Detail ITF
440:
441: DELETE FROM zx_rep_trx_detail_t itf
442: WHERE itf.request_id = p_request_id
443: AND NOT EXISTS ( SELECT 1
444: FROM zx_rep_trx_jx_ext_t ext
445: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);

Line 449: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );

445: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
446:
447: IF (g_level_statement >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
449: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
450: END IF;
451: END IF ;
452:
453: EXCEPTION

Line 474: FROM zx_rep_trx_detail_t dtl

470: SELECT dtl.detail_tax_line_id,
471: dtl.tax_rate_code
472: BULK COLLECT INTO l_detail_tax_line_id_tbl,
473: l_tax_rate_code_tbl
474: FROM zx_rep_trx_detail_t dtl
475: WHERE dtl.request_id = p_request_id;
476:
477: IF (g_level_statement >= g_current_runtime_level ) THEN
478: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

Line 587: -- zx_rep_trx_detail_t dtl

583: zx_reporting_codes_b rep_code,
584: zx_report_codes_assoc rep_ass,
585: zx_party_tax_profile ptp,
586: xle_etb_profiles xle_pf
587: -- zx_rep_trx_detail_t dtl
588: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
589: AND rep_type.reporting_type_code = 'FSO_REG_NUM'
590: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
591: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

Line 873: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

869: x_return_status VARCHAR2(1);
870: prev_event_class_mapping_id NUMBER;
871:
872: TYPE DETAIL_TAX_LINE_ID_TBL IS TABLE OF
873: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
874: TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
875: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
876: TYPE TRX_ID_TBL IS TABLE OF
877: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;

Line 875: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;

871:
872: TYPE DETAIL_TAX_LINE_ID_TBL IS TABLE OF
873: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
874: TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
875: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
876: TYPE TRX_ID_TBL IS TABLE OF
877: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
878: TYPE TRX_LINE_ID_TBL IS TABLE OF
879: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 877: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;

873: ZX_REP_TRX_DETAIL_T.DETAIL_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
874: TYPE EVENT_CLASS_MAPPING_ID_TBL IS TABLE OF
875: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
876: TYPE TRX_ID_TBL IS TABLE OF
877: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
878: TYPE TRX_LINE_ID_TBL IS TABLE OF
879: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
880: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
881: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 879: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

875: ZX_REP_TRX_DETAIL_T.EVENT_CLASS_MAPPING_ID%TYPE INDEX BY BINARY_INTEGER;
876: TYPE TRX_ID_TBL IS TABLE OF
877: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
878: TYPE TRX_LINE_ID_TBL IS TABLE OF
879: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
880: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
881: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
882: TYPE POS_TYPE_CODE_TBL IS TABLE OF
883: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 881: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

877: ZX_REP_TRX_DETAIL_T.TRX_ID%TYPE INDEX BY BINARY_INTEGER;
878: TYPE TRX_LINE_ID_TBL IS TABLE OF
879: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
880: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
881: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
882: TYPE POS_TYPE_CODE_TBL IS TABLE OF
883: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
884: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
885: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 883: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

879: ZX_REP_TRX_DETAIL_T.TRX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
880: TYPE TRX_LEVEL_TYPE_TBL IS TABLE OF
881: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
882: TYPE POS_TYPE_CODE_TBL IS TABLE OF
883: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
884: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
885: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
886: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
887: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 885: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

881: ZX_REP_TRX_DETAIL_T.TRX_LEVEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
882: TYPE POS_TYPE_CODE_TBL IS TABLE OF
883: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
884: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
885: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
886: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
887: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
888: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
889: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 887: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

883: ZX_REP_TRX_DETAIL_T.PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
884: TYPE SHIP_TO_LOCATION_ID_TBL IS TABLE OF
885: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
886: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
887: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
888: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
889: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
890: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
891: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 889: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

885: ZX_REP_TRX_DETAIL_T.SHIP_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
886: TYPE SHIP_FROM_LOCATION_ID_TBL IS TABLE OF
887: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
888: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
889: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
890: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
891: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
892: TYPE POA_LOCATION_ID_TBL IS TABLE OF
893: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 891: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

887: ZX_REP_TRX_DETAIL_T.SHIP_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
888: TYPE BILL_TO_LOCATION_ID_TBL IS TABLE OF
889: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
890: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
891: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
892: TYPE POA_LOCATION_ID_TBL IS TABLE OF
893: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
894: TYPE POO_LOCATION_ID_TBL IS TABLE OF
895: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 893: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

889: ZX_REP_TRX_DETAIL_T.BILL_TO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
890: TYPE BILL_FROM_LOCATION_ID_TBL IS TABLE OF
891: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
892: TYPE POA_LOCATION_ID_TBL IS TABLE OF
893: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
894: TYPE POO_LOCATION_ID_TBL IS TABLE OF
895: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
896: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
897: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 895: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;

891: ZX_REP_TRX_DETAIL_T.BILL_FROM_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
892: TYPE POA_LOCATION_ID_TBL IS TABLE OF
893: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
894: TYPE POO_LOCATION_ID_TBL IS TABLE OF
895: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
896: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
897: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
898: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
899:

Line 897: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

893: ZX_REP_TRX_DETAIL_T.POA_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
894: TYPE POO_LOCATION_ID_TBL IS TABLE OF
895: ZX_REP_TRX_DETAIL_T.POO_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
896: TYPE DEF_POS_TYPE_CODE_TBL IS TABLE OF
897: ZX_REP_TRX_DETAIL_T.DEF_PLACE_OF_SUPPLY_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
898: TYPE GEO_VAL_TBL IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
899:
900: l_detail_tax_line_id_tbl ZX_EXTRACT_PKG.DETAIL_TAX_LINE_ID_TBL;
901: l_event_class_mapping_id_tbl EVENT_CLASS_MAPPING_ID_TBL;

Line 991: FROM zx_rep_trx_detail_t itf

987: l_bill_from_location_id_tbl,
988: l_poa_location_id_tbl,
989: l_poo_location_id_tbl,
990: l_def_pos_type_code_tbl
991: FROM zx_rep_trx_detail_t itf
992: WHERE itf.request_id = P_REQUEST_ID;
993: EXCEPTION
994: WHEN OTHERS THEN
995: null;

Line 1205: DELETE from zx_rep_trx_detail_t itf

1201:
1202: -- Delete Unwanted lines from Detail ITF
1203:
1204: BEGIN
1205: DELETE from zx_rep_trx_detail_t itf
1206: WHERE itf.request_id = p_request_id
1207: AND NOT EXISTS ( SELECT 1
1208: FROM zx_rep_trx_jx_ext_t ext
1209: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);

Line 1213: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );

1209: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1210:
1211: IF ( g_level_statement>= g_current_runtime_level ) THEN
1212: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1213: 'After deletion from zx_rep_trx_detail_t : '||to_char(SQL%ROWCOUNT) );
1214: END IF;
1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN

Line 1365: zx_rep_trx_detail_t det ,

1361: l_trx_id_tbl,
1362: L_CCID_TBL,
1363: L_LEDGER_ID_TBL
1364: FROM
1365: zx_rep_trx_detail_t det ,
1366: ZX_REP_ACTG_EXT_T act
1367: WHERE det.request_id = p_request_id
1368: AND det.DETAIL_TAX_LINE_ID = ACT.DETAIL_TAX_LINE_ID(+);
1369:

Line 1461: FROM zx_rep_trx_detail_t dtl ,

1457: BULK COLLECT INTO
1458: l_detail_tax_line_id_tbl,
1459: l_trx_id_tbl,
1460: l_org_id_tbl
1461: FROM zx_rep_trx_detail_t dtl ,
1462: ar_receivable_applications_all cash
1463: WHERE
1464: dtl.trx_id = cash.applied_customer_trx_id
1465: AND dtl.request_id = p_request_id ;