[Home] [Help]
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
111: org_id ap_invoice_distributions_all.org_id%TYPE,
112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
755: CURSOR PO_Info_from_dist (c_po_dist_Id IN NUMBER) IS
756: SELECT pll.org_id, pll.quantity, pll.line_location_id,
757: pll.po_header_id, nvl(ph.rate,1), pll.po_release_id, mum.uom_code,
758: pd.quantity_ordered, pll.price_override
759: FROM po_line_locations_all pll, po_distributions_all pd,
760: po_headers_all ph, mtl_units_of_measure mum
761: WHERE pd.po_distribution_id = c_po_dist_Id
762: AND pd.line_location_id = pll.line_location_id
763: AND pll.po_header_id = ph.po_header_id
2310: ap_invoices_all ai,
2311: ap_supplier_sites_all pvs,
2312: ap_system_parameters_all asp,
2313: financials_system_params_all fsp,
2314: po_distributions_all pd,
2315: ap_invoice_lines_all parent_tax_line,
2316: ap_invoice_lines_all parent_item_line,
2317: ap_invoice_distributions_all parent_taxable_dist
2318: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2623: ap_invoices_all ai,
2624: ap_supplier_sites_all pvs,
2625: ap_system_parameters_all asp,
2626: financials_system_params_all fsp,
2627: po_distributions_all pd,
2628: ap_invoice_lines_all parent_tax_line,
2629: ap_invoice_lines_all parent_item_line,
2630: ap_invoice_distributions_all parent_taxable_dist,
2631: ap_line_temp_gt dist
2882: ap_invoice_distributions_all aid,
2883: ap_supplier_sites_all pvs,
2884: ap_system_parameters_all asp,
2885: financials_system_params_all fsp,
2886: po_distributions_all pd,
2887: ap_invoice_lines_all parent_tax_line,
2888: ap_invoice_lines_all parent_item_line,
2889: ap_invoice_distributions_all parent_taxable_dist
2890: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3112: ap_invoice_distributions_all aid,
3113: ap_supplier_sites_all pvs,
3114: ap_system_parameters_all asp,
3115: financials_system_params_all fsp,
3116: po_distributions_all pd,
3117: ap_invoice_lines_all parent_tax_line,
3118: ap_invoice_lines_all parent_item_line,
3119: ap_invoice_distributions_all parent_taxable_dist
3120: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3314: ap_invoices_all ai,
3315: ap_supplier_sites_all pvs,
3316: ap_system_parameters_all asp,
3317: financials_system_params_all fsp,
3318: po_distributions_all pd,
3319: ap_invoice_lines_all parent_item_line,
3320: ap_invoice_distributions_all parent_taxable_dist
3321: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3322: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3510: ap_self_assessed_tax_dist_all aid,
3511: ap_supplier_sites_all pvs,
3512: ap_system_parameters_all asp,
3513: financials_system_params_all fsp,
3514: po_distributions_all pd,
3515: ap_invoice_lines_all parent_tax_line,
3516: ap_invoice_lines_all parent_item_line,
3517: ap_invoice_distributions_all parent_taxable_dist
3518: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
7610: pl.unit_meas_lookup_code po_uom,
7611: D.matched_uom_lookup_code rcv_uom,
7612: rsl.item_id rcv_item_id
7613: FROM ap_invoice_distributions_all D,
7614: po_distributions_all PD,
7615: po_lines_all PL,
7616: po_line_locations_all PLL,
7617: rcv_transactions RTXN,
7618: rcv_shipment_lines RSL