DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_RELEASES_ALL

Line 1932: PO_RELEASES_ALL POR

1928: x_po_currency
1929: FROM PO_HEADERS_ALL POH,
1930: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
1931: GL_SETS_OF_BOOKS GSB,
1932: PO_RELEASES_ALL POR
1933: WHERE POR.po_release_id = x_object_id
1934: AND POH.po_header_id = POR.po_header_id
1935: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >
1936: AND FSP.set_of_books_id = GSB.set_of_books_id;

Line 2063: PO_RELEASES_ALL POR,

2059: c.precision
2060: INTO x_min_unit,
2061: x_precision
2062: FROM FND_CURRENCIES C,
2063: PO_RELEASES_ALL POR,
2064: PO_HEADERS_ALL PH
2065: WHERE POR.po_release_id = x_object_id
2066: AND PH.po_header_id = POR.PO_HEADER_ID
2067: AND C.currency_code = PH.CURRENCY_CODE;

Line 2635: PO_RELEASES_ALL POR

2631: l_po_currency
2632: FROM PO_HEADERS_ALL POH,
2633: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2634: GL_SETS_OF_BOOKS GSB,
2635: PO_RELEASES_ALL POR
2636: WHERE POR.po_release_id = p_object_id
2637: AND POH.po_header_id = POR.po_header_id
2638: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >
2639: AND FSP.set_of_books_id = GSB.set_of_books_id;

Line 2781: PO_RELEASES_ALL POR,

2777: c.precision
2778: INTO l_min_unit,
2779: l_precision
2780: FROM FND_CURRENCIES C,
2781: PO_RELEASES_ALL POR,
2782: PO_HEADERS_ALL PH
2783: WHERE POR.po_release_id = p_object_id
2784: AND PH.po_header_id = POR.PO_HEADER_ID
2785: AND C.currency_code = PH.CURRENCY_CODE;

Line 2885: p_release_id IN PO_RELEASES_ALL.PO_RELEASE_ID%TYPE

2881: ===================================================================================*/
2882: FUNCTION GET_RELEASE_LINE_TOTAL
2883: (
2884: p_line_id IN PO_LINES_ALL.PO_LINE_ID%TYPE ,
2885: p_release_id IN PO_RELEASES_ALL.PO_RELEASE_ID%TYPE
2886: )
2887: RETURN NUMBER
2888: IS
2889: x_min_unit NUMBER;