APPS.PO_AUTO_LINE_LOC_PROCESS_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 2284: linked_po_count = Decode((SELECT Count(1) FROM po_req_distributions_all d

2280: Decode(Nvl(line_location_id, -999),-999, p_lines.line_loc_id_tbl(i),-1), p_lines.line_loc_id_tbl(i)),
2281: -- Bug: 13948625, update linked_po_count, should be equal to number of req dist if autocreated.
2282: -- Updating count to 1 for Info lines(Funded and NonFunded) and Option lines.
2283: -- Updating count to number of distributions for Priced lines
2284: linked_po_count = Decode((SELECT Count(1) FROM po_req_distributions_all d
2285: WHERE d.requisition_line_id = l.requisition_line_id
2286: AND d.info_line_id IS NULL),
2287: 0,1,
2288: (SELECT Count(1) FROM po_req_distributions_all d WHERE d.requisition_line_id = l.requisition_line_id

Line 2288: (SELECT Count(1) FROM po_req_distributions_all d WHERE d.requisition_line_id = l.requisition_line_id

2284: linked_po_count = Decode((SELECT Count(1) FROM po_req_distributions_all d
2285: WHERE d.requisition_line_id = l.requisition_line_id
2286: AND d.info_line_id IS NULL),
2287: 0,1,
2288: (SELECT Count(1) FROM po_req_distributions_all d WHERE d.requisition_line_id = l.requisition_line_id
2289: AND d.info_line_id IS NULL)),
2290: --
2291: reqs_in_pool_flag = 'N',
2292: --