DBA Data[Home] [Help]

APPS.BOM_BOMRBOMC_XMLP_PKG dependencies on MFG_LOOKUPS

Line 106: TABLE_NAME := 'MFG_LOOKUPS1';

102: MTL_CATEGORY_SETS
103: WHERE CATEGORY_SET_ID = P_CATEGORY_SET_ID;
104: P_CATEGORY_SET := L_CATEGORY_SET;
105: END IF;
106: TABLE_NAME := 'MFG_LOOKUPS1';
107: SELECT
108: SUBSTR(L1.MEANING
109: ,1
110: ,40),

Line 125: MFG_LOOKUPS L1,

121: ,1
122: ,4)
123: INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
124: FROM
125: MFG_LOOKUPS L1,
126: MFG_LOOKUPS L2,
127: MFG_LOOKUPS L3,
128: MFG_LOOKUPS L4,
129: MFG_LOOKUPS L5

Line 126: MFG_LOOKUPS L2,

122: ,4)
123: INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
124: FROM
125: MFG_LOOKUPS L1,
126: MFG_LOOKUPS L2,
127: MFG_LOOKUPS L3,
128: MFG_LOOKUPS L4,
129: MFG_LOOKUPS L5
130: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'

Line 127: MFG_LOOKUPS L3,

123: INTO L_EXPLODE_OPTION,L_IMPL,L_RANGE_OPTION,L_PRINT_OPTION1,L_PLAN_FACTOR
124: FROM
125: MFG_LOOKUPS L1,
126: MFG_LOOKUPS L2,
127: MFG_LOOKUPS L3,
128: MFG_LOOKUPS L4,
129: MFG_LOOKUPS L5
130: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
131: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE

Line 128: MFG_LOOKUPS L4,

124: FROM
125: MFG_LOOKUPS L1,
126: MFG_LOOKUPS L2,
127: MFG_LOOKUPS L3,
128: MFG_LOOKUPS L4,
129: MFG_LOOKUPS L5
130: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
131: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
132: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'

Line 129: MFG_LOOKUPS L5

125: MFG_LOOKUPS L1,
126: MFG_LOOKUPS L2,
127: MFG_LOOKUPS L3,
128: MFG_LOOKUPS L4,
129: MFG_LOOKUPS L5
130: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
131: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
132: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
133: AND L2.LOOKUP_CODE = P_IMPL_FLAG

Line 140: TABLE_NAME := 'MFG_LOOKUPS2';

136: AND L4.LOOKUP_TYPE = 'SYS_YES_NO'
137: AND L4.LOOKUP_CODE = P_PRINT_OPTION1_FLAG
138: AND L5.LOOKUP_TYPE = 'SYS_YES_NO'
139: AND L5.LOOKUP_CODE = P_PLAN_FACTOR_FLAG;
140: TABLE_NAME := 'MFG_LOOKUPS2';
141: SELECT
142: SUBSTR(L1.MEANING
143: ,1
144: ,40),

Line 150: MFG_LOOKUPS L1,

146: ,1
147: ,40)
148: INTO L_ALT_OPTION,L_ORDER_BY
149: FROM
150: MFG_LOOKUPS L1,
151: MFG_LOOKUPS L2
152: WHERE L1.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
153: AND L1.LOOKUP_CODE = P_ALT_OPTION_TYPE
154: AND L2.LOOKUP_TYPE = 'BOM_BILL_SORT_ORDER_TYPE'

Line 151: MFG_LOOKUPS L2

147: ,40)
148: INTO L_ALT_OPTION,L_ORDER_BY
149: FROM
150: MFG_LOOKUPS L1,
151: MFG_LOOKUPS L2
152: WHERE L1.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
153: AND L1.LOOKUP_CODE = P_ALT_OPTION_TYPE
154: AND L2.LOOKUP_TYPE = 'BOM_BILL_SORT_ORDER_TYPE'
155: AND L2.LOOKUP_CODE = P_ORDER_BY_TYPE;