APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 591: ap_invoice_distributions_all D,

587: NULL, --status_code
588: 'N' self_assessed_flag --self_assessed_flag --bug7109594
589: FROM gl_period_statuses PER,
590: ap_invoices I,
591: ap_invoice_distributions_all D,
592: ap_invoice_lines L
593: WHERE D.invoice_id = I.invoice_id
594: AND D.invoice_line_number = L.line_number
595: AND L.invoice_id = D.invoice_id

Line 635: ap_invoice_distributions_all D,

631: NULL, --status_code
632: 'N' self_assessed_flag --self_assessed_flag --bug7109594
633: FROM gl_period_statuses PER,
634: ap_invoices I,
635: ap_invoice_distributions_all D,
636: ap_invoice_lines L,
637: po_distributions_all pod
638: WHERE D.invoice_id = I.invoice_id
639: AND D.invoice_line_number = L.line_number

Line 671: ap_invoice_distributions_all ainvd,

667: AND D.po_distribution_id = pod.po_distribution_id
668: AND NOT EXISTS ( select 'Advance Exists'
669: from po_distributions_all pod,
670: po_headers_all poh,
671: ap_invoice_distributions_all ainvd,
672: ap_invoices_all ainv,
673: po_doc_style_headers pdsa
674: where pod.po_distribution_id = D.po_distribution_id
675: and poh.po_header_id = pod.po_header_id

Line 767: ap_invoice_distributions_all ainvd,

763: AND T.po_distribution_id is NOT NULL
764: AND NOT EXISTS ( select 'Advance Exists'
765: from po_distributions_all pod,
766: po_headers_all poh,
767: ap_invoice_distributions_all ainvd,
768: ap_invoices_all ainv,
769: po_doc_style_headers pdsa
770: where pod.po_distribution_id = T.po_distribution_id
771: and poh.po_header_id = pod.po_header_id

Line 1140: UPDATE ap_invoice_distributions_all

1136: t_funds_dist_tab(i).inv_distribution_id
1137: AND bc_event_id is not null ;*/
1138: IF nvl(t_funds_dist_tab(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1139:
1140: UPDATE ap_invoice_distributions_all
1141: SET encumbered_flag = 'Y'
1142: WHERE invoice_distribution_id =
1143: t_funds_dist_tab(i).inv_distribution_id
1144: AND bc_event_id is not null ;

Line 1205: UPDATE ap_invoice_distributions_all

1201: t_funds_dist_tab(i).inv_distribution_id
1202: AND bc_event_id is not null ;*/
1203: IF nvl(t_funds_dist_tab(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1204:
1205: UPDATE ap_invoice_distributions_all
1206: SET encumbered_flag = 'Y'
1207: WHERE invoice_distribution_id =
1208: t_funds_dist_tab(i).inv_distribution_id
1209: AND bc_event_id is not null ;

Line 2269: FROM ap_invoice_distributions_all aid,

2265: AID.org_id, -- org_id
2266: NULL, --result_code
2267: NULL, --status_code
2268: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2269: FROM ap_invoice_distributions_all aid,
2270: ap_invoices_all ai,
2271: ap_invoice_lines_all ail,
2272: gl_period_statuses per
2273: WHERE ai.invoice_id = p_invoice_id

Line 2307: FROM ap_invoice_distributions_all aid,

2303: AID.org_id, -- org_id
2304: NULL, -- result_code
2305: NULL, -- status_code
2306: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2307: FROM ap_invoice_distributions_all aid,
2308: ap_invoices_all ai,
2309: ap_invoice_lines_all ail,
2310: gl_period_statuses per,
2311: po_distributions_all pod

Line 2339: ap_invoice_distributions_all ainvd,

2335: AND aid.po_distribution_id = pod.po_distribution_id
2336: AND NOT EXISTS ( select 'Advance Exists'
2337: from po_distributions_all pod,
2338: po_headers_all poh,
2339: ap_invoice_distributions_all ainvd,
2340: ap_invoices_all ainv,
2341: po_doc_style_headers pdsa
2342: where pod.po_distribution_id = aid.po_distribution_id
2343: and poh.po_header_id = pod.po_header_id

Line 2423: ap_invoice_distributions_all ainvd,

2419: AND t.po_distribution_id is NOT NULL
2420: AND NOT EXISTS ( select 'Advance Exists'
2421: from po_distributions_all pod,
2422: po_headers_all poh,
2423: ap_invoice_distributions_all ainvd,
2424: ap_invoices_all ainv,
2425: po_doc_style_headers pdsa
2426: where pod.po_distribution_id = t.po_distribution_id
2427: and poh.po_header_id = pod.po_header_id