[Home] [Help]
1054: -- Bug 2885953 - amended cursor below for performance enhancements
1055: -- Cursor c_max_req_date IS
1056: -- SELECT max(r.cbc_accounting_date)
1057: -- FROM po_requisition_headers r,
1058: -- po_distributions_v p
1059: -- WHERE r.requisition_header_id = p.requisition_header_id
1060: -- AND p.po_header_id = p_document_id;
1061: Cursor c_max_req_date IS
1062: SELECT max(porh.cbc_accounting_date)
1074: -- Bug 2885953 - amended cursor below for performance enhancements
1075: -- Cursor c_max_rel_req_date IS
1076: -- SELECT max(r.cbc_accounting_date)
1077: -- FROM po_requisition_headers r,
1078: -- po_distributions_v p
1079: -- WHERE r.requisition_header_id = p.requisition_header_id
1080: -- AND p.po_release_id = p_document_id;
1081: Cursor c_max_rel_req_date IS
1082: SELECT max(porh.cbc_accounting_date)
1646: Select p.req_distribution_id,
1647: p.gl_encumbered_date PO_GL_Date,
1648: p.set_of_books_id sob_id,
1649: h.cbc_accounting_date PO_Acct_Date
1650: From PO_Distributions_V p,
1651: PO_Headers h
1652: Where p.po_header_id = p_document_id
1653: And p.po_line_id = nvl(p_line_id, p.po_line_id)
1654: And p.line_location_id = nvl(p_line_location_id, p.line_location_id)
1662: -- Select p.req_distribution_id,
1663: -- p.gl_encumbered_date rel_gl_date,
1664: -- p.set_of_books_id sob_id,
1665: -- r.cbc_accounting_date rel_acct_date
1666: -- From po_distributions_v p,
1667: -- po_releases r
1668: -- Where p.po_release_id = p_document_id
1669: -- And p.line_location_id = nvl(p_line_location_id, p.line_location_id)
1670: -- And p.po_release_id = r.po_release_id
1693: Select p.gl_encumbered_date rel_gl_date,
1694: p.source_distribution_id,
1695: p.set_of_books_id sob_id,
1696: r.cbc_accounting_date rel_acct_date
1697: From po_distributions_v P,
1698: po_releases R
1699: Where p.po_release_id = p_document_id
1700: And p.line_location_id = nvl(p_line_location_id, p.line_location_id)
1701: And p.po_release_id = r.po_release_id;