[Home] [Help]
36:
37:
38: -- cursor to return max and min gl dates for requisition distributions
39:
40: CURSOR c_req_dates(p_document_id po_requisition_lines.requisition_header_id%TYPE)
41: IS
42: SELECT max(gl_encumbered_date)
43: ,min(gl_encumbered_date)
44: FROM po_req_distributions dists
41: IS
42: SELECT max(gl_encumbered_date)
43: ,min(gl_encumbered_date)
44: FROM po_req_distributions dists
45: ,po_requisition_lines lines
46: WHERE dists.requisition_line_id = lines.requisition_line_id
47: AND lines.requisition_header_id = p_document_id
48: AND NVL(lines.closed_code,'X') <> 'FINALLY CLOSED'
49: AND NVL(lines.cancel_flag,'N') = 'N'
787: min(prh.cbc_accounting_date)
788: INTO l_max_cbc_acc_date,
789: l_min_cbc_acc_date
790: FROM po_requisition_headers prh,
791: po_requisition_lines prl,
792: po_line_locations poll
793: WHERE poll.po_header_id = p_document_id
794: AND poll.line_location_id = prl.line_location_id
795: AND prl.requisition_header_id = prh.requisition_header_id
806: min(prh.cbc_accounting_date)
807: INTO l_max_cbc_acc_date,
808: l_min_cbc_acc_date
809: FROM po_requisition_headers prh,
810: po_requisition_lines prl,
811: po_line_locations poll
812: WHERE poll.po_release_id = p_document_id
813: AND prl.line_location_id = poll.line_location_id
814: AND prl.requisition_header_id = prh.requisition_header_id
894: MIN(poh.cbc_accounting_date)
895: INTO l_max_bpa_accounting_date,
896: l_min_bpa_accounting_date
897: FROM po_headers poh,
898: Po_requisition_lines prl
899: WHERE prl.requisition_header_id = p_document_id
900: AND prl.blanket_po_header_id = poh.po_header_id
901: AND prl.blanket_po_header_id IS NOT NULL
902: AND poh.type_lookup_code = 'BLANKET'
1061: Cursor c_max_req_date IS
1062: SELECT max(porh.cbc_accounting_date)
1063: FROM po_requisition_headers porh,
1064: po_distributions pod,
1065: po_requisition_lines porl,
1066: po_req_distributions pord
1067: WHERE pod.po_header_id = p_document_id
1068: AND pod.req_distribution_id = pord.distribution_id(+)
1069: AND pord.requisition_line_id = porl.requisition_line_id(+)
1081: Cursor c_max_rel_req_date IS
1082: SELECT max(porh.cbc_accounting_date)
1083: FROM po_requisition_headers porh,
1084: po_distributions pod,
1085: po_requisition_lines porl,
1086: po_req_distributions pord
1087: WHERE pod.po_release_id = p_document_id
1088: AND pod.req_distribution_id = pord.distribution_id(+)
1089: AND pord.requisition_line_id = porl.requisition_line_id(+)
1124: -- for the requisitions.
1125: Cursor c_max_bpa_req_date IS
1126: SELECT MAX(bpa_h.cbc_accounting_date)
1127: FROM po_headers bpa_h,
1128: Po_requisition_lines prl
1129: WHERE prl.requisition_header_id = p_document_id
1130: AND prl.blanket_po_header_id = bpa_h.po_header_id
1131: AND prl.blanket_po_header_id IS NOT NULL
1132: AND bpa_h.type_lookup_code = 'BLANKET'
1676: r.cbc_accounting_date rel_acct_date
1677: From po_distributions pod,
1678: po_releases r,
1679: po_requisition_headers porh,
1680: po_requisition_lines porl,
1681: po_req_distributions pord
1682: Where pod.po_release_id = p_document_id
1683: And pod.line_location_id = nvl(p_line_location_id, pod.line_location_id)
1684: And pod.po_release_id = r.po_release_id