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 3527: FROM po_line_locations_all poll, po_lines_all po

3523: AND pol.unit_meas_lookup_code IS NOT NULL
3524: AND pol.line_num = p_line_no
3525: AND pol.unit_meas_lookup_code = mum.unit_of_measure
3526: AND pol.po_line_id IN (SELECT poll.po_line_id
3527: FROM po_line_locations_all poll, po_lines_all po
3528: WHERE poll.po_header_id = po.po_header_id
3529: AND Nvl(poll.approved_flag,'N') = 'Y'
3530: AND Nvl(poll.cancel_flag,'N') = 'N'
3531: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3564: FROM po_line_locations_all poll, po_lines_all po

3560: AND pol.unit_meas_lookup_code IS NOT NULL
3561: AND pol.unit_meas_lookup_code = mum.unit_of_measure
3562: AND pol.item_description = p_item_desc
3563: AND pol.po_line_id IN (SELECT poll.po_line_id
3564: FROM po_line_locations_all poll, po_lines_all po
3565: WHERE poll.po_header_id = po.po_header_id
3566: AND Nvl(poll.approved_flag,'N') = 'Y'
3567: AND Nvl(poll.cancel_flag,'N') = 'N'
3568: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3602: FROM po_line_locations_all poll, po_lines_all po

3598: WHERE pol.po_header_id = p_po_header_id
3599: AND pol.unit_meas_lookup_code IS NOT NULL
3600: AND pol.item_id = p_item_id
3601: AND pol.po_line_id IN (SELECT poll.po_line_id
3602: FROM po_line_locations_all poll, po_lines_all po
3603: WHERE poll.po_header_id = po.po_header_id
3604: AND Nvl(poll.approved_flag,'N') = 'Y'
3605: AND Nvl(poll.cancel_flag,'N') = 'N'
3606: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')

Line 3631: FROM po_line_locations_all poll, po_lines_all po

3627: AND pol.unit_meas_lookup_code IS NOT NULL
3628: AND pol.item_id = p_item_id
3629: AND mum.UNIT_OF_MEASURE(+) = pol.UNIT_MEAS_LOOKUP_CODE
3630: AND pol.po_line_id IN (SELECT poll.po_line_id
3631: FROM po_line_locations_all poll, po_lines_all po
3632: WHERE poll.po_header_id = po.po_header_id
3633: AND Nvl(poll.approved_flag,'N') = 'Y'
3634: AND Nvl(poll.cancel_flag,'N') = 'N'
3635: AND Nvl(poll.closed_code,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING')