[Home] [Help]
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')
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')
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')
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')
6168:
6169: IF p_document_type = 'PO' THEN
6170: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6171: INTO l_project_tasks_count
6172: FROM po_distributions_all pod, po_lines_all pol
6173: WHERE pod.po_header_id = p_po_header_id
6174: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6175: AND pod.project_id IS NOT NULL
6176: AND pod.po_header_id = pol.po_header_id
6183: GROUP BY pod.project_id, pod.task_id;
6184:
6185: SELECT COUNT(*)
6186: INTO l_distributions_count
6187: FROM po_distributions_all pod, po_lines_all pol
6188: WHERE pod.po_header_id = p_po_header_id
6189: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6190: AND pod.po_header_id = pol.po_header_id
6191: AND pod.po_line_id = pol.po_line_id
6315: ELSIF p_document_type = 'RECEIPT' THEN
6316: IF p_po_header_id IS NOT NULL THEN
6317: SELECT COUNT(COUNT(*)) -- get the no of project/tasks combinations
6318: INTO l_project_tasks_count
6319: FROM po_distributions_all pod, po_lines_all pol
6320: WHERE pod.po_header_id = p_po_header_id
6321: AND pod.project_id IS NOT NULL
6322: AND pod.po_header_id = pol.po_header_id
6323: AND pod.po_line_id = pol.po_line_id
6329: GROUP BY pod.project_id, pod.task_id;
6330:
6331: SELECT COUNT(*)
6332: INTO l_distributions_count
6333: FROM po_distributions_all pod, po_lines_all pol
6334: WHERE pod.po_header_id = p_po_header_id
6335: AND pod.po_header_id = pol.po_header_id
6336: AND pod.po_line_id = pol.po_line_id
6337: AND (p_item_id IS NULL OR pol.item_id = p_item_id)
6724: IF p_document_type = 'PO' THEN
6725: BEGIN
6726: SELECT pod.task_id
6727: INTO l_task_id
6728: FROM po_distributions_all pod, po_lines_all pol
6729: WHERE pod.po_header_id = p_po_header_id
6730: AND pod.po_line_id = NVL(p_po_line_id, pod.po_line_id)
6731: AND pod.project_id = p_project_id
6732: AND pod.po_header_id = pol.po_header_id
6810: IF p_po_header_id IS NOT NULL THEN
6811: BEGIN
6812: SELECT pod.task_id
6813: INTO l_task_id
6814: FROM po_distributions_all pod, po_lines_all pol
6815: WHERE pod.po_header_id = p_po_header_id
6816: AND pod.project_id = p_project_id
6817: AND pod.po_header_id = pol.po_header_id
6818: AND pod.po_line_id = pol.po_line_id