DBA Data[Home] [Help]

APPS.BOM_BOMRDRSO_XMLP_PKG dependencies on MFG_LOOKUPS

Line 8: L_DTL_SUM_CHAR MFG_LOOKUPS.MEANING%TYPE;

4: BEGIN
5: DECLARE
6: L_CURRENCY_CODE GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
7: L_ORG_NAME ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
8: L_DTL_SUM_CHAR MFG_LOOKUPS.MEANING%TYPE;
9: BEGIN
10: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
11: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
12: SELECT

Line 20: MFG_LOOKUPS LU

16: INTO L_CURRENCY_CODE,L_ORG_NAME,L_DTL_SUM_CHAR
17: FROM
18: GL_SETS_OF_BOOKS BOOKS,
19: ORG_ORGANIZATION_DEFINITIONS ORG,
20: MFG_LOOKUPS LU
21: WHERE ORG.ORGANIZATION_ID = P_ORG_ID
22: AND BOOKS.SET_OF_BOOKS_ID = ORG.SET_OF_BOOKS_ID
23: AND LU.LOOKUP_CODE = P_DETAIL_OR_SUMMARY
24: AND LU.LOOKUP_TYPE = 'CST_RPT_DETAIL_OPTION';