DBA Data[Home] [Help]

APPS.BOM_CSTROMMA_XMLP_PKG dependencies on MFG_LOOKUPS

Line 84: MFG_LOOKUPS LU1,

80: ORG_ORGANIZATION_DEFINITIONS O,
81: FND_CURRENCIES FC,
82: MTL_CATEGORY_SETS MCS,
83: MTL_PARAMETERS MP,
84: MFG_LOOKUPS LU1,
85: MFG_LOOKUPS LU2,
86: MFG_LOOKUPS LU3
87: WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
88: AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG

Line 85: MFG_LOOKUPS LU2,

81: FND_CURRENCIES FC,
82: MTL_CATEGORY_SETS MCS,
83: MTL_PARAMETERS MP,
84: MFG_LOOKUPS LU1,
85: MFG_LOOKUPS LU2,
86: MFG_LOOKUPS LU3
87: WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
88: AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
89: AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET

Line 86: MFG_LOOKUPS LU3

82: MTL_CATEGORY_SETS MCS,
83: MTL_PARAMETERS MP,
84: MFG_LOOKUPS LU1,
85: MFG_LOOKUPS LU2,
86: MFG_LOOKUPS LU3
87: WHERE FC.CURRENCY_CODE = LP_CURRENCY_CODE
88: AND MP.ORGANIZATION_ID = L_IF_OU_NOT_INVORG
89: AND MCS.CATEGORY_SET_ID = P_CATEGORY_SET
90: AND O.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID

Line 139: MFG_LOOKUPS

135: SELECT
136: MEANING
137: INTO P_CONFIG_ITEM_DTLS_OPTS
138: FROM
139: MFG_LOOKUPS
140: WHERE LOOKUP_TYPE = 'SYS_YES_NO'
141: AND LOOKUP_CODE = NVL(P_CONFIG_ITEM_DETAILS
142: ,2);
143: