DBA Data[Home] [Help]

APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on PO_LINES_ALL

Line 670: l_uom_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;

666: IS
667:
668: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_UOM';
669:
670: l_uom_code PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
671:
672:
673: -- Modified the cursor for bug 6010684
674: Cursor l_uom_code_csr Is

Line 678: FROM PO_LINES_ALL

674: Cursor l_uom_code_csr Is
675: SELECT UOM_CODE
676: FROM MTL_UNITS_OF_MEASURE
677: WHERE UNIT_OF_MEASURE = (SELECT UNIT_MEAS_LOOKUP_CODE
678: FROM PO_LINES_ALL
679: WHERE PO_HEADER_ID = P_DOC_ID);
680: --Cursor l_uom_code_csr Is
681: --SELECT UNIT_MEAS_LOOKUP_CODE
682: --FROM PO_LINES_ALL

Line 682: --FROM PO_LINES_ALL

678: FROM PO_LINES_ALL
679: WHERE PO_HEADER_ID = P_DOC_ID);
680: --Cursor l_uom_code_csr Is
681: --SELECT UNIT_MEAS_LOOKUP_CODE
682: --FROM PO_LINES_ALL
683: --WHERE PO_HEADER_ID = P_DOC_ID;
684:
685: BEGIN
686: