APPS.JAI_AP_MATCH_TAX_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 57: FROM po_distributions_all

53: ship_to_location_id
54: FROM po_line_locations_all
55: WHERE line_location_id IN ( SELECT line_location_id
56:
57: FROM po_distributions_all
58: WHERE po_distribution_id = po_dist_id) ;
59:
60: ln_organization_id NUMBER;
61: ln_location_id NUMBER;

Line 701: po_distributions_all pod,

697: api.last_updated_by,
698: api.invoice_date
699: FROM ap_invoices_all api,
700: ap_invoice_distributions_all apd,
701: po_distributions_all pod,
702: po_headers_all poh
703: WHERE apd.invoice_id = api.invoice_id
704: AND pod.po_header_id = poh.po_header_id
705: AND apd.po_distribution_id = pod.po_distribution_id

Line 723: FROM po_distributions_all

719:
720:
721: CURSOR from_po_distributions(po_dist_id NUMBER) IS
722: SELECT line_location_id, po_line_id
723: FROM po_distributions_all
724: WHERE po_distribution_id = po_dist_id;
725:
726: ln_min_dist_line_num NUMBER ;
727: -- End of Bug # 4445989

Line 1341: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;

1337: r_jai_regimes c_jai_regimes%rowtype;
1338: r_service_regime_tax_type c_regime_tax_type%rowtype;
1339: lv_is_item_an_expense varchar2(20); /* Service */
1340: lv_accounting_method_option varchar2(20); /* Service */
1341: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
1342: /* Service Tax */
1343: ln_base_amount number ; -- kunkumar for bug 5593895
1344: /* Bug 5358788. Added by Lakshmi Gopalsami
1345: * Defined variable for fetching VAT regime/

Line 2580: FROM po_distributions_all

2576: IF po_dist_id IS NULL
2577: THEN
2578: SELECT Min(po_distribution_id)
2579: INTO ln_po_dist_id
2580: FROM po_distributions_all
2581: WHERE po_line_id = ln_po_line_id
2582: AND line_location_id = ln_po_line_location_id;
2583: END IF;
2584: /*end bug 9346307*/

Line 7265: po_distributions_all pod,

7261: api.last_updated_by,
7262: api.invoice_date
7263: FROM ap_invoices_all api,
7264: ap_invoice_distributions_all apd,
7265: po_distributions_all pod,
7266: po_headers_all poh
7267: WHERE api.invoice_id = inv_id
7268: AND api.invoice_id = apd.invoice_id
7269: AND pod.po_header_id = poh.po_header_id

Line 7626: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;

7622: r_jai_regimes c_jai_regimes%rowtype;
7623: r_service_regime_tax_type c_regime_tax_type%rowtype;
7624: lv_is_item_an_expense varchar2(20); /* Service */
7625: lv_accounting_method_option varchar2(20); /* Service */
7626: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
7627: /* Service Tax */
7628:
7629: /* Bug 5358788. Added by Lakshmi Gopalsami
7630: * Defined variable for fetching VAT regime/