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.INV_RCV_COMMON_APIS dependencies on PO_LINES_ALL

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

Line 6704: FROM po_distributions_all pod, po_lines_all pol

6700:
6701: IF p_document_type = 'PO' THEN
6702: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6703: INTO l_project_tasks_count
6704: FROM po_distributions_all pod, po_lines_all pol
6705: WHERE pod.po_header_id = p_po_header_id
6706: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6707: AND pod.project_id IS NOT NULL
6708: AND pod.po_header_id = pol.po_header_id

Line 6719: FROM po_distributions_all pod, po_lines_all pol

6715: GROUP BY pod.project_id, pod.task_id;
6716:
6717: SELECT COUNT(*)
6718: INTO l_distributions_count
6719: FROM po_distributions_all pod, po_lines_all pol
6720: WHERE pod.po_header_id = p_po_header_id
6721: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6722: AND pod.po_header_id = pol.po_header_id
6723: AND pod.po_line_id = pol.po_line_id

Line 6851: FROM po_distributions_all pod, po_lines_all pol

6847: ELSIF p_document_type = 'RECEIPT' THEN
6848: IF p_po_header_id IS NOT NULL THEN
6849: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6850: INTO l_project_tasks_count
6851: FROM po_distributions_all pod, po_lines_all pol
6852: WHERE pod.po_header_id = p_po_header_id
6853: AND pod.project_id IS NOT NULL
6854: AND pod.po_header_id = pol.po_header_id
6855: AND pod.po_line_id = pol.po_line_id

Line 6865: FROM po_distributions_all pod, po_lines_all pol

6861: GROUP BY pod.project_id, pod.task_id;
6862:
6863: SELECT COUNT(*)
6864: INTO l_distributions_count
6865: FROM po_distributions_all pod, po_lines_all pol
6866: WHERE pod.po_header_id = p_po_header_id
6867: AND pod.po_header_id = pol.po_header_id
6868: AND pod.po_line_id = pol.po_line_id
6869: AND (p_item_id IS NULL OR pol.item_id = p_item_id)

Line 7260: FROM po_distributions_all pod, po_lines_all pol

7256: IF p_document_type = 'PO' THEN
7257: BEGIN
7258: SELECT pod.task_id
7259: INTO l_task_id
7260: FROM po_distributions_all pod, po_lines_all pol
7261: WHERE pod.po_header_id = p_po_header_id
7262: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
7263: AND pod.project_id = p_project_id
7264: AND pod.po_header_id = pol.po_header_id

Line 7346: FROM po_distributions_all pod, po_lines_all pol

7342: IF p_po_header_id IS NOT NULL THEN
7343: BEGIN
7344: SELECT pod.task_id
7345: INTO l_task_id
7346: FROM po_distributions_all pod, po_lines_all pol
7347: WHERE pod.po_header_id = p_po_header_id
7348: AND pod.project_id = p_project_id
7349: AND pod.po_header_id = pol.po_header_id
7350: AND pod.po_line_id = pol.po_line_id