APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on PO_DISTRIBUTIONS_ALL

Line 602: FROM po_distributions_all

598: SELECT ship_to_organization_id,
599: ship_to_location_id
600: FROM po_line_locations_all
601: WHERE line_location_id IN ( SELECT line_location_id
602: FROM po_distributions_all
603: WHERE po_distribution_id = po_dist_id) ;
604:
605: ln_organization_id NUMBER;
606: ln_location_id NUMBER;

Line 3144: po_distributions_all pod,

3140: api.last_updated_by,
3141: api.invoice_date
3142: FROM ap_invoices_all api,
3143: ap_invoice_distributions_all apd,
3144: po_distributions_all pod,
3145: po_headers_all poh
3146: WHERE apd.invoice_id = api.invoice_id
3147: AND pod.po_header_id = poh.po_header_id
3148: AND apd.po_distribution_id = pod.po_distribution_id

Line 3166: FROM po_distributions_all

3162:
3163:
3164: CURSOR from_po_distributions(po_dist_id NUMBER) IS
3165: SELECT line_location_id, po_line_id
3166: FROM po_distributions_all
3167: WHERE po_distribution_id = po_dist_id;
3168:
3169: ln_min_dist_line_num NUMBER ;
3170: -- End of Bug # 4445989

Line 3693: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;

3689: r_jai_regimes c_jai_regimes%rowtype;
3690: r_service_regime_tax_type c_regime_tax_type%rowtype;
3691: lv_is_item_an_expense varchar2(20); /* Service */
3692: lv_accounting_method_option varchar2(20); /* Service */
3693: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
3694: /* Service Tax */
3695: ln_base_amount number ; -- kunkumar for bug 5593895
3696: /* Bug 5358788. Added by Lakshmi Gopalsami
3697: * Defined variable for fetching VAT regime/

Line 4079: FROM po_distributions_all

4075: THEN
4076:
4077: SELECT Min(po_distribution_id)
4078: INTO ln_po_dist_id
4079: FROM po_distributions_all
4080: WHERE po_line_id = ln_po_line_id
4081: AND line_location_id = ln_po_line_location_id;
4082:
4083: END IF;

Line 5414: po_distributions_all pod,

5410: api.last_updated_by,
5411: api.invoice_date
5412: FROM ap_invoices_all api,
5413: ap_invoice_distributions_all apd,
5414: po_distributions_all pod,
5415: po_headers_all poh
5416: WHERE api.invoice_id = inv_id
5417: AND api.invoice_id = apd.invoice_id
5418: AND pod.po_header_id = poh.po_header_id

Line 5762: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;

5758: r_jai_regimes c_jai_regimes%rowtype;
5759: r_service_regime_tax_type c_regime_tax_type%rowtype;
5760: lv_is_item_an_expense varchar2(20); /* Service */
5761: lv_accounting_method_option varchar2(20); /* Service */
5762: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
5763: /* Service Tax */
5764:
5765: /* Bug 5358788. Added by Lakshmi Gopalsami
5766: * Defined variable for fetching VAT regime/