APPS.IGC_CBC_PO_GRP dependencies on PO_REQ_DISTRIBUTIONS

Line 44: FROM po_req_distributions dists

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
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'

Line 1066: po_req_distributions pord

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(+)
1070: AND porl.requisition_header_id = porh.requisition_header_id;

Line 1086: po_req_distributions pord

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(+)
1090: AND porl.requisition_header_id = porh.requisition_header_id;

Line 1681: po_req_distributions pord

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
1685: And porh.requisition_header_id is not null

Line 1707: From po_req_distributions

1703: l_po_dists_sch_rel c_po_dists_sch_rel%rowtype;
1704:
1705: Cursor c_req_dists (p_req_dist_id NUMBER) IS
1706: Select gl_encumbered_date
1707: From po_req_distributions
1708: Where distribution_id = p_req_dist_id;
1709:
1710: l_req_gl_date Date;
1711:

Line 1721: From po_req_distributions

1717: l_po_gl_date Date;
1718:
1719: Cursor c_linked_req_dists (p_req_dist_id NUMBER) IS
1720: Select distribution_id, gl_encumbered_date
1721: From po_req_distributions
1722: Where source_req_distribution_id = p_req_dist_id;
1723:
1724: l_linked_req c_linked_req_dists%rowtype;
1725:

Line 1837: UPDATE po_req_distributions

1833:
1834: --If validations passed, then roll forward the date
1835:
1836: IF l_passed_validation THEN
1837: UPDATE po_req_distributions
1838: SET gl_encumbered_date = p_action_date
1839: WHERE distribution_id = l_linked_req.distribution_id;
1840: END IF;
1841:

Line 1857: UPDATE po_req_distributions

1853:
1854: --If validation passed, then roll forward date.
1855:
1856: IF l_passed_validation THEN
1857: UPDATE po_req_distributions
1858: SET gl_encumbered_date = p_action_date
1859: WHERE distribution_id = l_po_dists_po.req_distribution_id;
1860: END IF;
1861:

Line 1957: UPDATE po_req_distributions

1953:
1954: --If all validations pass, then roll forward linked requisition distribution gl_date
1955:
1956: IF l_passed_validation THEN
1957: UPDATE po_req_distributions
1958: SET gl_encumbered_date = p_action_date
1959: WHERE distribution_id = l_linked_req.distribution_id;
1960: END IF;
1961:

Line 1981: UPDATE po_req_distributions

1977: END IF;
1978:
1979: -- If all validations pass, then roll forward requisition distribution gl date
1980: IF l_passed_validation THEN
1981: UPDATE po_req_distributions
1982: SET gl_encumbered_date = p_action_date
1983: WHERE distribution_id = l_po_dists_bla_rel.req_distribution_id;
1984: END IF;
1985: