DBA Data[Home] [Help]

APPS.AR_GTA_CONSOLIDATE_PROC dependencies on FND_LOOKUP_VALUES_VL

Line 220: FROM AR_gta_consol_temp jgct, fnd_lookup_values_vl lk

216: --modified by Jixun for bug#16274922 end
217: jgct.failed_reason AS "FailedReason",
218: l_success_invs AS "ConsolidatedInvs"))
219: INTO l_success
220: FROM AR_gta_consol_temp jgct, fnd_lookup_values_vl lk
221: WHERE jgct.seq = l_consol_seq
222: AND jgct.invoice_type = lk.lookup_code
223: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';
224: SELECT Xmlconcat(l_success_all, l_success)

Line 271: FROM AR_gta_consol_temp jgct, fnd_lookup_values_vl lk

267: jgct.failed_reason AS "FailedReason",
268: l_warning_invs AS "ConsolidatedInvs")))
269:
270: INTO l_warning
271: FROM AR_gta_consol_temp jgct, fnd_lookup_values_vl lk
272: WHERE jgct.seq = l_consol_seq
273: AND jgct.invoice_type = lk.lookup_code
274: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';
275: SELECT Xmlconcat(l_warning_all, l_warning)

Line 327: FROM AR_gta_consol_temp jgct, fnd_lookup_values_vl lk

323: l_failed_invs AS
324: "ConsolidatedInvs")))
325:
326: INTO l_failed
327: FROM AR_gta_consol_temp jgct, fnd_lookup_values_vl lk
328: WHERE jgct.seq = l_consol_seq
329: AND jgct.invoice_type = lk.lookup_code
330: AND lk.lookup_type = 'AR_GTA_INVOICE_TYPE';
331: