DBA Data[Home] [Help]

APPS.WIP_WIPREJVR_XMLP_PKG dependencies on MFG_LOOKUPS

Line 70: MFG_LOOKUPS RPT_SORT_OPT,

66: FROM
67: FND_CURRENCIES FC,
68: GL_SETS_OF_BOOKS SOB,
69: ORG_ORGANIZATION_DEFINITIONS OOD,
70: MFG_LOOKUPS RPT_SORT_OPT,
71: MFG_LOOKUPS RPT_RUN_OPT,
72: MFG_LOOKUPS CLS_TYPE
73: WHERE OOD.ORGANIZATION_ID = ORG_ID
74: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 71: MFG_LOOKUPS RPT_RUN_OPT,

67: FND_CURRENCIES FC,
68: GL_SETS_OF_BOOKS SOB,
69: ORG_ORGANIZATION_DEFINITIONS OOD,
70: MFG_LOOKUPS RPT_SORT_OPT,
71: MFG_LOOKUPS RPT_RUN_OPT,
72: MFG_LOOKUPS CLS_TYPE
73: WHERE OOD.ORGANIZATION_ID = ORG_ID
74: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
75: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE

Line 72: MFG_LOOKUPS CLS_TYPE

68: GL_SETS_OF_BOOKS SOB,
69: ORG_ORGANIZATION_DEFINITIONS OOD,
70: MFG_LOOKUPS RPT_SORT_OPT,
71: MFG_LOOKUPS RPT_RUN_OPT,
72: MFG_LOOKUPS CLS_TYPE
73: WHERE OOD.ORGANIZATION_ID = ORG_ID
74: AND OOD.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
75: AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE
76: AND FC.ENABLED_FLAG = 'Y'

Line 90: MFG_LOOKUPS STS_TYPE

86: SELECT
87: STS_TYPE.MEANING
88: INTO STATUS_TYPE_NAME
89: FROM
90: MFG_LOOKUPS STS_TYPE
91: WHERE STS_TYPE.LOOKUP_TYPE = 'WIP_JOB_STATUS'
92: AND STS_TYPE.LOOKUP_CODE = STATUS_TYPE;
93: END IF;
94: IF (JOB_FROM IS NULL) AND (JOB_TO IS NULL) THEN