APPS.INV_RCV_COMMON_APIS dependencies on PO_LINE_LOCATIONS_ALL

Line 1975: * Routing ID is defined at PO line-location level (po_line_locations_all)

1971:
1972: /*************************************************
1973: * Name: get_po_routing_id
1974: * This API returns routing id for a given PO header ID
1975: * Routing ID is defined at PO line-location level (po_line_locations_all)
1976: * We use the following rule to set headers routing ID
1977: * If there is one line detail needs inspection the entire PO needs inspection
1978: * elsif there is one line detail needs direct receiving the entire PO direct
1979: * else (all line detail are standard) the entire PO is standard

Line 4010: FROM po_line_locations_all poll, po_lines_all po

4006: AND pol.unit_meas_lookup_code IS NOT NULL
4007: AND pol.line_num = p_line_no
4008: AND pol.unit_meas_lookup_code = mum.unit_of_measure
4009: AND pol.po_line_id IN (SELECT poll.po_line_id
4010: FROM po_line_locations_all poll, po_lines_all po
4011: WHERE poll.po_header_id = po.po_header_id
4012: AND Nvl(poll.approved_flag,'N') = 'Y'
4013: AND Nvl(poll.cancel_flag,'N') = 'N'
4014: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4047: FROM po_line_locations_all poll, po_lines_all po

4043: AND pol.unit_meas_lookup_code IS NOT NULL
4044: AND pol.unit_meas_lookup_code = mum.unit_of_measure
4045: AND pol.item_description = p_item_desc
4046: AND pol.po_line_id IN (SELECT poll.po_line_id
4047: FROM po_line_locations_all poll, po_lines_all po
4048: WHERE poll.po_header_id = po.po_header_id
4049: AND Nvl(poll.approved_flag,'N') = 'Y'
4050: AND Nvl(poll.cancel_flag,'N') = 'N'
4051: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4085: FROM po_line_locations_all poll, po_lines_all po

4081: WHERE pol.po_header_id = p_po_header_id
4082: AND pol.unit_meas_lookup_code IS NOT NULL
4083: AND pol.item_id = p_item_id
4084: AND pol.po_line_id IN (SELECT poll.po_line_id
4085: FROM po_line_locations_all poll, po_lines_all po
4086: WHERE poll.po_header_id = po.po_header_id
4087: AND Nvl(poll.approved_flag,'N') = 'Y'
4088: AND Nvl(poll.cancel_flag,'N') = 'N'
4089: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4114: FROM po_line_locations_all poll, po_lines_all po

4110: AND pol.unit_meas_lookup_code IS NOT NULL
4111: AND pol.item_id = p_item_id
4112: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
4113: AND pol.po_line_id IN (SELECT poll.po_line_id
4114: FROM po_line_locations_all poll, po_lines_all po
4115: WHERE poll.po_header_id = po.po_header_id
4116: AND Nvl(poll.approved_flag,'N') = 'Y'
4117: AND Nvl(poll.cancel_flag,'N') = 'N'
4118: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 4681: FROM po_distributions_all pda,po_lines_all pol, po_line_locations_all pll, hr_locations hl

4677: BEGIN
4678: /* bug 14305407 modified the query to improve the performance */
4679: SELECT distinct(hl.location_code)
4680: INTO x_location_code
4681: FROM po_distributions_all pda,po_lines_all pol, po_line_locations_all pll, hr_locations hl
4682: WHERE pda.po_header_id = pll.po_header_id
4683: AND pda.line_location_id = pll.line_location_id
4684: AND pda.po_line_id = pll.po_line_id
4685: AND pda.po_header_id = pol.po_header_id