[Home] [Help]
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;
537: api.last_updated_by,
538: api.invoice_date
539: FROM ap_invoices_all api,
540: ap_invoice_distributions_all apd,
541: po_distributions_all pod,
542: po_headers_all poh
543: WHERE apd.invoice_id = api.invoice_id
544: AND pod.po_header_id = poh.po_header_id
545: AND apd.po_distribution_id = pod.po_distribution_id
559:
560:
561: CURSOR from_po_distributions(po_dist_id NUMBER) IS
562: SELECT line_location_id, po_line_id
563: FROM po_distributions_all
564: WHERE po_distribution_id = po_dist_id;
565:
566: ln_min_dist_line_num NUMBER ;
567: -- End of Bug # 4445989
1020: r_jai_regimes c_jai_regimes%rowtype;
1021: r_service_regime_tax_type c_regime_tax_type%rowtype;
1022: lv_is_item_an_expense varchar2(20); /* Service */
1023: lv_accounting_method_option varchar2(20); /* Service */
1024: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
1025: /* Service Tax */
1026: ln_base_amount number ; -- kunkumar for bug 5593895
1027: /* Bug 5358788. Added by Lakshmi Gopalsami
1028: * Defined variable for fetching VAT regime/
5712: api.last_updated_by,
5713: api.invoice_date
5714: FROM ap_invoices_all api,
5715: ap_invoice_distributions_all apd,
5716: po_distributions_all pod,
5717: po_headers_all poh
5718: WHERE api.invoice_id = inv_id
5719: AND api.invoice_id = apd.invoice_id
5720: AND pod.po_header_id = poh.po_header_id
6070: r_jai_regimes c_jai_regimes%rowtype;
6071: r_service_regime_tax_type c_regime_tax_type%rowtype;
6072: lv_is_item_an_expense varchar2(20); /* Service */
6073: lv_accounting_method_option varchar2(20); /* Service */
6074: lv_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%type;
6075: /* Service Tax */
6076:
6077: /* Bug 5358788. Added by Lakshmi Gopalsami
6078: * Defined variable for fetching VAT regime/