eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 2140: from po_distributions_all

2136: SELECT costing_group_id
2137: FROM pjm_project_parameters
2138: WHERE project_id in
2139: (select project_id
2140: from po_distributions_all
2141: where po_distribution_id =cp_po_distribution_id
2142: );
2143:
2144: /* cursor to get the material account pertaining to the cost group passed */

Line 2247: FROM po_distributions_all

2243: AND secondary_inventory_name = cp_subinventory_code;
2244:
2245: cursor c_fetch_expense_acct1(cp_po_distribution_id in number) IS
2246: SELECT code_combination_id
2247: FROM po_distributions_all
2248: WHERE po_distribution_id = cp_po_distribution_id;
2249:
2250: CURSOR c_fetch_expense_acct2(cp_po_line_location_id in number) IS
2251: SELECT code_combination_id

Line 2252: FROM po_distributions_all

2248: WHERE po_distribution_id = cp_po_distribution_id;
2249:
2250: CURSOR c_fetch_expense_acct2(cp_po_line_location_id in number) IS
2251: SELECT code_combination_id
2252: FROM po_distributions_all
2253: WHERE line_location_id = cp_po_line_location_id
2254: AND creation_date IN
2255: (SELECT max(creation_date)
2256: FROM po_distributions_all

Line 2256: FROM po_distributions_all

2252: FROM po_distributions_all
2253: WHERE line_location_id = cp_po_line_location_id
2254: AND creation_date IN
2255: (SELECT max(creation_date)
2256: FROM po_distributions_all
2257: WHERE line_location_id = cp_po_line_location_id
2258: );
2259:
2260: CURSOR c_fetch_expense_acct3(cp_organization_id in number, cp_item_id in number) IS