DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on AP_INVOICES_ALL

Line 189: ap_invoices_all ai

185: ,aid.invoice_line_number
186: ,G_SRC_TYP_UNACCT_DISTS
187: ,G_SRC_TAB_AP_INV_DISTS_ALL
188: from
189: ap_invoices_all ai
190: ,ap_invoice_distributions_all aid
191: ,ap_org_attributes_gt org_gtt
192: where
193: ai.invoice_id = aid.invoice_id

Line 255: ap_invoices_all ai

251: ,aid.invoice_line_number
252: ,G_SRC_TYP_UNACCT_DISTS
253: ,G_SRC_TAB_AP_INV_DISTS_ALL
254: from
255: ap_invoices_all ai
256: ,ap_invoice_distributions_all aid
257: ,ap_org_attributes_gt org_gtt
258: where
259: ai.invoice_id = aid.invoice_id

Line 326: ap_invoices_all ai

322: ,astd.detail_tax_dist_id
323: ,G_SRC_TYP_UNACCT_DISTS
324: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
325: from
326: ap_invoices_all ai
327: ,ap_self_assessed_tax_dist_all astd
328: ,ap_org_attributes_gt org_gtt
329: where
330: ai.invoice_id = astd.invoice_id

Line 387: ap_invoices_all ai

383: ,astd.detail_tax_dist_id
384: ,G_SRC_TYP_UNACCT_DISTS
385: ,G_SRC_TAB_AP_SELF_TAX_DIST_ALL
386: from
387: ap_invoices_all ai
388: ,ap_self_assessed_tax_dist_all astd
389: ,ap_org_attributes_gt org_gtt
390: where
391: ai.invoice_id = astd.invoice_id

Line 449: ap_invoices_all ai

445: ,ai.cancelled_date
446: ,G_SRC_TYP_LINES_WITHOUT_DISTS
447: ,G_SRC_TAB_AP_INV_LINES_ALL
448: from
449: ap_invoices_all ai
450: ,ap_invoice_lines_all ail
451: ,ap_org_attributes_gt org_gtt
452: where
453: ai.invoice_id = ail.invoice_id

Line 511: ap_invoices_all ai

507: ,ai.cancelled_date
508: ,G_SRC_TYP_LINES_WITHOUT_DISTS
509: ,G_SRC_TAB_AP_INV_LINES_ALL
510: from
511: ap_invoices_all ai
512: ,ap_invoice_lines_all ail
513: ,ap_org_attributes_gt org_gtt
514: where
515: ai.invoice_id = ail.invoice_id

Line 587: from ap_invoices_all ai

583: ,ai.cancelled_date
584: ,ai.legal_entity_id
585: ,G_SRC_TYP_UNACCT_PREPAY_HIST
586: ,G_SRC_TAB_AP_PREPAY_HIST
587: from ap_invoices_all ai
588: ,ap_prepay_history_all apph
589: ,ap_org_attributes_gt org_gtt
590: where
591: ai.invoice_id = apph.invoice_id

Line 636: from ap_invoices_all ai

632: ,ai.cancelled_date
633: ,ai.legal_entity_id
634: ,G_SRC_TYP_UNACCT_PREPAY_HIST
635: ,G_SRC_TAB_AP_PREPAY_HIST
636: from ap_invoices_all ai
637: ,ap_prepay_history_all apph
638: ,ap_org_attributes_gt org_gtt
639: where
640: ai.invoice_id = apph.invoice_id