[Home] [Help]
1071: ) IS
1072: /*Bug 5879769 bduvarag start*/
1073: /* CURSOR c_inv_organization_id(cp_po_distribution_id IN NUMBER) IS
1074: SELECT b.ship_to_organization_id
1075: FROM po_distributions_all a, po_line_locations_all b
1076: WHERE a.line_location_id = b.line_location_id
1077: AND a.po_distribution_id = cp_po_distribution_id;*/
1078:
1079: -- Added for bug#7191302 by Xiao, begin.
1914: AND invoice_id IN ( SELECT invoice_id
1915: FROM ap_invoice_distributions_all
1916: WHERE po_distribution_id IN ( SELECT pda.po_distribution_id
1917: FROM po_line_locations_all pll,
1918: po_distributions_all pda,
1919: jai_po_line_locations jpll
1920: WHERE pll.line_location_id = jpll.line_location_id
1921: AND pll.line_location_id = pda.line_location_id
1922: AND pll.ship_to_organization_id = p_organization_id
2134:
2135:
2136: CURSOR c_item_id(cp_po_distribution_id IN NUMBER) IS
2137: SELECT b.item_id
2138: FROM po_distributions_all a, po_lines_all b
2139: WHERE po_distribution_id = cp_po_distribution_id
2140: AND a.po_line_id = b.po_line_id;
2141:
2142: CURSOR c_batch_references(cp_batch_id IN NUMBER, cp_source IN VARCHAR2) IS
2209: WHERE org_id = p_org_id
2210: AND po_distribution_id in
2211: (SELECT pda.po_distribution_id
2212: FROM po_line_locations_all pll,
2213: po_distributions_all pda,
2214: jai_po_line_locations jpll
2215: WHERE pll.line_location_id = jpll.line_location_id
2216: AND pll.line_location_id = pda.line_location_id
2217: AND pll.ship_to_organization_id = p_organization_id