APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 631: po_distributions_all pod,

627: api.last_updated_by,
628: api.invoice_date
629: FROM ap_invoices_all api,
630: ap_invoice_distributions_all apd,
631: po_distributions_all pod,
632: po_headers_all poh
633: WHERE apd.invoice_id = api.invoice_id
634: AND pod.po_header_id = poh.po_header_id
635: AND apd.po_distribution_id = pod.po_distribution_id

Line 1570: FROM po_lines_all pla,po_distributions_all pda

1566:
1567:
1568: CURSOR c_get_item_id IS
1569: SELECT item_id
1570: FROM po_lines_all pla,po_distributions_all pda
1571: WHERE pla.po_line_id = pda.po_line_id
1572: AND pda.po_distribution_id = pr_ap_inv_line_item.po_distribution_id;
1573:
1574: CURSOR get_account_type IS

Line 1586: FROM Po_Distributions_All

1582: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
1583: FROM Rcv_Shipment_Headers
1584: WHERE Receipt_Num = receiptnum )
1585: AND Po_Line_location_Id = ( SELECT Line_Location_Id
1586: FROM Po_Distributions_All
1587: WHERE Po_Distribution_Id = pr_ap_inv_line_item.po_line_location_id)
1588: AND To_Organization_Id = invorg;
1589:
1590: cursor c_regime_tax_type(cp_regime_code varchar2, cp_tax_type varchar2) is

Line 1685: FROM po_distributions_all

1681: IF pr_ap_inv_line_item.po_distribution_id IS NULL THEN
1682:
1683: SELECT Min(po_distribution_id)
1684: INTO ln_po_dist_id
1685: FROM po_distributions_all
1686: WHERE po_line_id = pr_ap_inv_line_item.po_line_id
1687: AND line_location_id = pr_ap_inv_line_item.po_line_location_id;
1688:
1689: END IF;

Line 3106: FROM Po_Distributions_All

3102: FROM Hr_Locations
3103: WHERE Location_Id = ( SELECT Ship_To_Location_Id
3104: FROM Po_Headers_All
3105: WHERE Po_Header_Id = ( SELECT Po_Header_Id
3106: FROM Po_Distributions_All
3107: WHERE Po_Distribution_Id = c_po_dist_id
3108: )
3109: );
3110: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ,c_po_dist_id NUMBER) IS

Line 3117: FROM Po_Distributions_All

3113: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
3114: FROM Rcv_Shipment_Headers
3115: WHERE Receipt_Num = receiptnum )
3116: AND Po_Line_location_Id = ( SELECT Line_Location_Id
3117: FROM Po_Distributions_All
3118: WHERE Po_Distribution_Id = c_po_dist_id)
3119: AND To_Organization_Id = invorg;
3120:
3121: CURSOR Fetch_Shipment_Count_Cur( invorg IN NUMBER,v_shipment_header_id NUMBER ) IS

Line 3497: FROM po_line_locations_all plla, po_distributions_all pod

3493: FROM rcv_transactions
3494: WHERE transaction_id = pn_rcv_trx_id;
3495: CURSOR c_po_organization_id IS
3496: SELECT ship_to_organization_id, ship_to_location_id
3497: FROM po_line_locations_all plla, po_distributions_all pod
3498: WHERE plla.line_location_id = pod.line_location_id AND
3499: pod.po_distribution_id = pn_po_dist_id;
3500: l_api_name CONSTANT VARCHAR2(30) := 'get_org_loc_id';
3501: BEGIN