DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000012_BC_PKG dependencies on ZX_AP_TAX_JRNL_LINE_DESC_V

Line 36622: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

36618: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36619: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36620: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36621: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
36622: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
36623: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36624: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36625: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
36626: WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 36837: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

36833: FROM xla_events_gt xet
36834: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
36835: , FV_XLA_AP_REF_V l3
36836: , ZX_AP_DEF_TAX_EXTRACT_V l4
36837: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
36838: , fnd_lookup_values fvl8
36839: , fnd_lookup_values fvl11
36840: , fnd_lookup_values fvl42
36841: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)

Line 37041: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

37037: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
37038: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
37039: TYPE t_array_source_47 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
37040: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
37041: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
37042: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
37043: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
37044: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
37045: TYPE t_array_source_53 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 37252: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

37248: FROM xla_events_gt xet
37249: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
37250: , FV_XLA_AP_REF_V l3
37251: , ZX_AP_DEF_TAX_EXTRACT_V l4
37252: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
37253: , fnd_lookup_values fvl8
37254: , fnd_lookup_values fvl11
37255: , fnd_lookup_values fvl42
37256: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 38966: WHEN 36 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

38962: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38963: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38964: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38965: WHEN 35 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
38966: WHEN 36 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
38967: WHEN 37 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38968: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38969: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
38970: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 39182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

39178: FROM xla_events_gt xet
39179: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39180: , FV_XLA_AP_REF_V l3
39181: , ZX_AP_DEF_TAX_EXTRACT_V l4
39182: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39183: , fnd_lookup_values fvl8
39184: , fnd_lookup_values fvl11
39185: , fnd_lookup_values fvl42
39186: , (select rownum r from all_objects where rownum <= 44 and owner = p_apps_owner)

Line 39385: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

39381: TYPE t_array_source_41 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.DEFERRED_START_DATE%TYPE INDEX BY BINARY_INTEGER;
39382: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
39383: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
39384: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
39385: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
39386: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
39387: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
39388: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
39389: TYPE t_array_source_53 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 39597: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

39593: FROM xla_events_gt xet
39594: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
39595: , FV_XLA_AP_REF_V l3
39596: , ZX_AP_DEF_TAX_EXTRACT_V l4
39597: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
39598: , fnd_lookup_values fvl8
39599: , fnd_lookup_values fvl11
39600: , fnd_lookup_values fvl42
39601: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 41312: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

41308: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41309: WHEN 34 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41310: WHEN 35 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41311: WHEN 36 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
41312: WHEN 37 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
41313: WHEN 38 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41314: WHEN 39 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41315: WHEN 40 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
41316: WHEN 41 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 41582: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

41578: FROM xla_events_gt xet
41579: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
41580: , FV_XLA_AP_REF_V l4
41581: , ZX_AP_DEF_TAX_EXTRACT_V l5
41582: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
41583: , fnd_lookup_values fvl8
41584: , fnd_lookup_values fvl11
41585: , fnd_lookup_values fvl42
41586: , (select rownum r from all_objects where rownum <= 55 and owner = p_apps_owner)

Line 41787: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

41783: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
41784: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
41785: TYPE t_array_source_47 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
41786: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
41787: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
41788: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
41789: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
41790: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
41791: TYPE t_array_source_53 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.ENCUMBRANCE_BASE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 42041: , ZX_AP_TAX_JRNL_LINE_DESC_V l6

42037: FROM xla_events_gt xet
42038: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
42039: , FV_XLA_AP_REF_V l4
42040: , ZX_AP_DEF_TAX_EXTRACT_V l5
42041: , ZX_AP_TAX_JRNL_LINE_DESC_V l6
42042: , fnd_lookup_values fvl8
42043: , fnd_lookup_values fvl11
42044: , fnd_lookup_values fvl42
42045: WHERE xet.event_id between x_first_event_id and x_last_event_id

Line 44322: WHEN 29 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'

44318: WHEN 25 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44319: WHEN 26 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44320: WHEN 27 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44321: WHEN 28 THEN 'ZX_AP_DEF_TAX_EXTRACT_V'
44322: WHEN 29 THEN 'ZX_AP_TAX_JRNL_LINE_DESC_V'
44323: WHEN 30 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44324: WHEN 31 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44325: WHEN 32 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'
44326: WHEN 33 THEN 'AP_EXTRACT_INVOICE_DTLS_BC_V'

Line 44498: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

44494: FROM xla_events_gt xet
44495: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44496: , FV_XLA_AP_REF_V l3
44497: , ZX_AP_DEF_TAX_EXTRACT_V l4
44498: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44499: , fnd_lookup_values fvl42
44500: , (select rownum r from all_objects where rownum <= 35 and owner = p_apps_owner)
44501: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
44502: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 44682: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;

44678: TYPE t_array_source_42 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.OVERRIDE_ACCTD_AMT_FLAG%TYPE INDEX BY BINARY_INTEGER;
44679: TYPE t_array_source_46 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_PARENT_REVERSAL_ID%TYPE INDEX BY BINARY_INTEGER;
44680: TYPE t_array_source_47 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_STAT_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
44681: TYPE t_array_source_48 IS TABLE OF ZX_AP_DEF_TAX_EXTRACT_V.TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
44682: TYPE t_array_source_49 IS TABLE OF ZX_AP_TAX_JRNL_LINE_DESC_V.REC_NREC_TAX_DIST_ID%TYPE INDEX BY BINARY_INTEGER;
44683: TYPE t_array_source_50 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.SUMMARY_TAX_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
44684: TYPE t_array_source_51 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_CR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
44685: TYPE t_array_source_52 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.UPG_DR_ENC_TYPE_ID%TYPE INDEX BY BINARY_INTEGER;
44686: TYPE t_array_source_55 IS TABLE OF AP_EXTRACT_INVOICE_DTLS_BC_V.AID_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

Line 44868: , ZX_AP_TAX_JRNL_LINE_DESC_V l5

44864: FROM xla_events_gt xet
44865: , AP_EXTRACT_INVOICE_DTLS_BC_V l1
44866: , FV_XLA_AP_REF_V l3
44867: , ZX_AP_DEF_TAX_EXTRACT_V l4
44868: , ZX_AP_TAX_JRNL_LINE_DESC_V l5
44869: , fnd_lookup_values fvl42
44870: WHERE xet.event_id between x_first_event_id and x_last_event_id
44871: and xet.event_date between p_pad_start_date and p_pad_end_date
44872: and xet.event_class_code = C_EVENT_CLASS_CODE