DBA Data[Home] [Help]

APPS.XLA_00200_AAD_S_000012_BC_PKG dependencies on FND_LOOKUP_VALUES

Line 36511: , fnd_lookup_values fvl13

36507: ELSE null
36508: END source_meaning
36509: FROM xla_events_gt xet
36510: , AP_INVOICE_EXTRACT_HEADER_V h2
36511: , fnd_lookup_values fvl13
36512: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
36513: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36514: AND xet.event_class_code = C_EVENT_CLASS_CODE
36515: AND h2.event_id = xet.event_id

Line 36838: , fnd_lookup_values fvl8

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)
36842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 36839: , fnd_lookup_values fvl11

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)
36842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36843: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 36840: , fnd_lookup_values fvl42

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)
36842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
36843: AND xet.event_class_code = C_EVENT_CLASS_CODE
36844: AND l1.event_id = xet.event_id

Line 36988: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

36984: l_balance_type_code VARCHAR2(1) :=NULL;
36985: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
36986:
36987: --
36988: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
36989: --
36990:
36991: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
36992: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 37158: , fnd_lookup_values fvl13

37154: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
37155: , h2.INV_DOC_SEQUENCE_VALUE source_73
37156: FROM xla_events_gt xet
37157: , AP_INVOICE_EXTRACT_HEADER_V h2
37158: , fnd_lookup_values fvl13
37159: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
37160: and xet.event_class_code = C_EVENT_CLASS_CODE
37161: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
37162: AND fvl13.lookup_type(+) = 'INVOICE TYPE'

Line 37253: , fnd_lookup_values fvl8

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
37257: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 37254: , fnd_lookup_values fvl11

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
37257: and xet.event_date between p_pad_start_date and p_pad_end_date
37258: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 37255: , fnd_lookup_values fvl42

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
37257: and xet.event_date between p_pad_start_date and p_pad_end_date
37258: and xet.event_class_code = C_EVENT_CLASS_CODE
37259: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 38856: , fnd_lookup_values fvl13

38852: ELSE null
38853: END source_meaning
38854: FROM xla_events_gt xet
38855: , AP_INVOICE_EXTRACT_HEADER_V h2
38856: , fnd_lookup_values fvl13
38857: ,(select rownum r from all_objects where rownum <= 13 and owner = p_apps_owner)
38858: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
38859: AND xet.event_class_code = C_EVENT_CLASS_CODE
38860: AND h2.event_id = xet.event_id

Line 39183: , fnd_lookup_values fvl8

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)
39187: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 39184: , fnd_lookup_values fvl11

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)
39187: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
39188: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 39185: , fnd_lookup_values fvl42

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)
39187: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
39188: AND xet.event_class_code = C_EVENT_CLASS_CODE
39189: AND l1.event_id = xet.event_id

Line 39333: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

39329: l_balance_type_code VARCHAR2(1) :=NULL;
39330: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
39331:
39332: --
39333: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
39334: --
39335:
39336: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
39337: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 39503: , fnd_lookup_values fvl13

39499: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
39500: , h2.INV_DOC_SEQUENCE_VALUE source_73
39501: FROM xla_events_gt xet
39502: , AP_INVOICE_EXTRACT_HEADER_V h2
39503: , fnd_lookup_values fvl13
39504: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
39505: and xet.event_class_code = C_EVENT_CLASS_CODE
39506: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
39507: AND fvl13.lookup_type(+) = 'INVOICE TYPE'

Line 39598: , fnd_lookup_values fvl8

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
39602: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 39599: , fnd_lookup_values fvl11

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
39602: and xet.event_date between p_pad_start_date and p_pad_end_date
39603: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 39600: , fnd_lookup_values fvl42

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
39602: and xet.event_date between p_pad_start_date and p_pad_end_date
39603: and xet.event_class_code = C_EVENT_CLASS_CODE
39604: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 41196: , fnd_lookup_values fvl13

41192: END source_meaning
41193: FROM xla_events_gt xet
41194: , AP_INVOICE_EXTRACT_HEADER_V h2
41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41196: , fnd_lookup_values fvl13
41197: , fnd_lookup_values fvl60
41198: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
41199: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
41200: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 41197: , fnd_lookup_values fvl60

41193: FROM xla_events_gt xet
41194: , AP_INVOICE_EXTRACT_HEADER_V h2
41195: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41196: , fnd_lookup_values fvl13
41197: , fnd_lookup_values fvl60
41198: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
41199: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
41200: AND xet.event_class_code = C_EVENT_CLASS_CODE
41201: AND h2.event_id = xet.event_id

Line 41583: , fnd_lookup_values fvl8

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)
41587: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date

Line 41584: , fnd_lookup_values fvl11

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)
41587: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
41588: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 41585: , fnd_lookup_values fvl42

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)
41587: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
41588: AND xet.event_class_code = C_EVENT_CLASS_CODE
41589: AND l1.event_id = xet.event_id

Line 41733: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

41729: l_balance_type_code VARCHAR2(1) :=NULL;
41730: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
41731:
41732: --
41733: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
41734: --
41735:
41736: TYPE t_array_source_7 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_PAYMENT_STATUS_FLAG%TYPE INDEX BY BINARY_INTEGER;
41737: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 41931: , fnd_lookup_values fvl13

41927: , h2.INV_DOC_SEQUENCE_VALUE source_73
41928: FROM xla_events_gt xet
41929: , AP_INVOICE_EXTRACT_HEADER_V h2
41930: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41931: , fnd_lookup_values fvl13
41932: , fnd_lookup_values fvl60
41933: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
41934: and xet.event_class_code = C_EVENT_CLASS_CODE
41935: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id

Line 41932: , fnd_lookup_values fvl60

41928: FROM xla_events_gt xet
41929: , AP_INVOICE_EXTRACT_HEADER_V h2
41930: , AP_SYSTEM_PARAMETERS_EXTRACT_V h3
41931: , fnd_lookup_values fvl13
41932: , fnd_lookup_values fvl60
41933: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
41934: and xet.event_class_code = C_EVENT_CLASS_CODE
41935: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
41936: AND h3.asp_org_id = h2.ai_org_id AND fvl13.lookup_type(+) = 'INVOICE TYPE'

Line 42042: , fnd_lookup_values fvl8

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
42046: and xet.event_date between p_pad_start_date and p_pad_end_date

Line 42043: , fnd_lookup_values fvl11

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
42046: and xet.event_date between p_pad_start_date and p_pad_end_date
42047: and xet.event_class_code = C_EVENT_CLASS_CODE

Line 42044: , fnd_lookup_values fvl42

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
42046: and xet.event_date between p_pad_start_date and p_pad_end_date
42047: and xet.event_class_code = C_EVENT_CLASS_CODE
42048: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id

Line 44219: , fnd_lookup_values fvl13

44215: ELSE null
44216: END source_meaning
44217: FROM xla_events_gt xet
44218: , AP_INVOICE_EXTRACT_HEADER_V h2
44219: , fnd_lookup_values fvl13
44220: ,(select rownum r from all_objects where rownum <= 12 and owner = p_apps_owner)
44221: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
44222: AND xet.event_class_code = C_EVENT_CLASS_CODE
44223: AND h2.event_id = xet.event_id

Line 44499: , fnd_lookup_values fvl42

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
44503: AND l1.event_id = xet.event_id

Line 44638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

44634: l_balance_type_code VARCHAR2(1) :=NULL;
44635: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
44636:
44637: --
44638: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
44639: --
44640:
44641: TYPE t_array_source_13 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
44642: TYPE t_array_source_20 IS TABLE OF AP_INVOICE_EXTRACT_HEADER_V.AI_INVOICE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 44785: , fnd_lookup_values fvl13

44781: , h2.INV_DOC_SEQUENCE_IDENTIFIER source_72
44782: , h2.INV_DOC_SEQUENCE_VALUE source_73
44783: FROM xla_events_gt xet
44784: , AP_INVOICE_EXTRACT_HEADER_V h2
44785: , fnd_lookup_values fvl13
44786: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
44787: and xet.event_class_code = C_EVENT_CLASS_CODE
44788: and xet.event_status_code <> 'N' AND h2.event_id = xet.event_id
44789: AND fvl13.lookup_type(+) = 'INVOICE TYPE'

Line 44869: , fnd_lookup_values fvl42

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
44873: and xet.event_status_code <> 'N' AND l1.event_id = xet.event_id