[Home] [Help]
2060: x_po_currency
2061: FROM PO_HEADERS_ALL POH,
2062: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2063: GL_SETS_OF_BOOKS GSB,
2064: PO_RELEASES_ALL POR
2065: WHERE POR.po_release_id = x_object_id
2066: AND POH.po_header_id = POR.po_header_id
2067: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >
2068: AND FSP.set_of_books_id = GSB.set_of_books_id;
2191: c.precision
2192: INTO x_min_unit,
2193: x_precision
2194: FROM FND_CURRENCIES C,
2195: PO_RELEASES_ALL POR,
2196: PO_HEADERS_ALL PH
2197: WHERE POR.po_release_id = x_object_id
2198: AND PH.po_header_id = POR.PO_HEADER_ID
2199: AND C.currency_code = PH.CURRENCY_CODE;
2763: l_po_currency
2764: FROM PO_HEADERS_ALL POH,
2765: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2766: GL_SETS_OF_BOOKS GSB,
2767: PO_RELEASES_ALL POR
2768: WHERE POR.po_release_id = p_object_id
2769: AND POH.po_header_id = POR.po_header_id
2770: AND NVL(POR.org_id,-99) = NVL(FSP.org_id,-99) --< Bug 3549096 >
2771: AND FSP.set_of_books_id = GSB.set_of_books_id;
2909: c.precision
2910: INTO l_min_unit,
2911: l_precision
2912: FROM FND_CURRENCIES C,
2913: PO_RELEASES_ALL POR,
2914: PO_HEADERS_ALL PH
2915: WHERE POR.po_release_id = p_object_id
2916: AND PH.po_header_id = POR.PO_HEADER_ID
2917: AND C.currency_code = PH.CURRENCY_CODE;
3013: ===================================================================================*/
3014: FUNCTION GET_RELEASE_LINE_TOTAL
3015: (
3016: p_line_id IN PO_LINES_ALL.PO_LINE_ID%TYPE ,
3017: p_release_id IN PO_RELEASES_ALL.PO_RELEASE_ID%TYPE
3018: )
3019: RETURN NUMBER
3020: IS
3021: x_min_unit NUMBER;
7353: , l_cancel_flag
7354: , l_closed_code
7355: , l_frozen_flag
7356: , l_user_hold_flag
7357: FROM po_releases por
7358: , po_lookup_codes plc_sta
7359: , po_lookup_codes plc_can
7360: , po_lookup_codes plc_clo
7361: , po_lookup_codes plc_fro