DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 461: SELECT /*+ leading(APIDG aagt algt) use_hash(algt) use_hash(aagt) index(XDL XLA_DISTRIBUTION_LINKS_N3) USE_NL(API) index( API AP_INVOICES_U1) */ NULL,-- changed hint Bug 7284987 / 7392117 /7438251

457: line_type_lookup_code,
458: po_distribution_id,
459: line_status
460: )
461: SELECT /*+ leading(APIDG aagt algt) use_hash(algt) use_hash(aagt) index(XDL XLA_DISTRIBUTION_LINKS_N3) USE_NL(API) index( API AP_INVOICES_U1) */ NULL,-- changed hint Bug 7284987 / 7392117 /7438251
462: NULL,
463: NULL,
464: --bugfix:5686771 added the NVL
465: RTRIM(SUBSTRB(NVL(APIDG.description,APIL.description),1,80)),

Line 623: xla_distribution_links XDL,

619: po_vendors POV,
620: po_line_types_b POLT,
621: mtl_system_items MTLSI,
622: financials_system_params_all FSP,
623: xla_distribution_links XDL,
624: xla_ae_headers XAH,
625: xla_ae_lines XAL,
626: ap_alc_ledger_gt ALGT,
627: ap_acct_class_code_gt AAGT

Line 863: SELECT /*+ leading(APIDG aagt algt) use_hash(algt) use_hash(aagt) index(XDL XLA_DISTRIBUTION_LINKS_N3) USE_NL(API) index( API AP_INVOICES_U1) */ NULL,-- changed hint Bug 7284987 / 7392117 /7438251

859: line_type_lookup_code,
860: po_distribution_id,
861: line_status
862: )
863: SELECT /*+ leading(APIDG aagt algt) use_hash(algt) use_hash(aagt) index(XDL XLA_DISTRIBUTION_LINKS_N3) USE_NL(API) index( API AP_INVOICES_U1) */ NULL,-- changed hint Bug 7284987 / 7392117 /7438251
864: NULL,
865: NULL,
866: --bugfix:5686771 added the NVL
867: RTRIM(SUBSTRB(NVL(APIDG.description,APIL.description),1,80)),

Line 1025: xla_distribution_links XDL,

1021: po_vendors POV,
1022: po_line_types_b POLT,
1023: mtl_system_items MTLSI,
1024: financials_system_params_all FSP,
1025: xla_distribution_links XDL,
1026: xla_ae_headers XAH,
1027: xla_ae_lines XAL,
1028: ap_alc_ledger_gt ALGT,
1029: ap_acct_class_code_gt AAGT

Line 1424: xla_distribution_links XDL,

1420: po_headers_all POH,
1421: po_lines_all POL,
1422: po_vendors POV,
1423: --po_line_types_b POLT,
1424: xla_distribution_links XDL,
1425: xla_ae_headers XAH,
1426: xla_ae_lines XAL,
1427: ap_alc_ledger_gt ALGT,
1428: ap_acct_class_code_gt AAGT