DBA Data[Home] [Help]

APPS.GMS_AP_API dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 42: from ap_expense_report_lines_all erl,

38: erl.task_id TASK_ID,
39: erl.distribution_line_number distribution_line_number,
40: apd.invoice_distribution_id invoice_distribution_id,
41: apd.award_id award_set_id
42: from ap_expense_report_lines_all erl,
43: ap_invoice_distributions_all apd,
44: pa_projects_all p,
45: gms_project_types gpt
46: where report_header_id = X_report_header_id

Line 63: from AP_EXPENSE_REPORT_LINES_ALL ERL,

59: erl.task_id TASK_ID,
60: erl.distribution_line_number distribution_line_number,
61: apsat.invoice_distribution_id invoice_distribution_id,
62: apsat.award_id award_set_id
63: from AP_EXPENSE_REPORT_LINES_ALL ERL,
64: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
65: pa_projects_all p,
66: GMS_PROJECT_TYPES GPT
67: where report_header_id = X_report_header_id