APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on MFG_LOOKUPS

Line 140: MFG_LOOKUPS L1,

136: ,1
137: ,40)
138: INTO L_EXPLODE_OPTION,L_ALT_OPTION,L_RANGE_OPTION,L_ORDER_BY
139: FROM
140: MFG_LOOKUPS L1,
141: MFG_LOOKUPS L2,
142: MFG_LOOKUPS L3,
143: MFG_LOOKUPS L4
144: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'

Line 141: MFG_LOOKUPS L2,

137: ,40)
138: INTO L_EXPLODE_OPTION,L_ALT_OPTION,L_RANGE_OPTION,L_ORDER_BY
139: FROM
140: MFG_LOOKUPS L1,
141: MFG_LOOKUPS L2,
142: MFG_LOOKUPS L3,
143: MFG_LOOKUPS L4
144: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
145: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE

Line 142: MFG_LOOKUPS L3,

138: INTO L_EXPLODE_OPTION,L_ALT_OPTION,L_RANGE_OPTION,L_ORDER_BY
139: FROM
140: MFG_LOOKUPS L1,
141: MFG_LOOKUPS L2,
142: MFG_LOOKUPS L3,
143: MFG_LOOKUPS L4
144: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
145: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
146: AND L2.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'

Line 143: MFG_LOOKUPS L4

139: FROM
140: MFG_LOOKUPS L1,
141: MFG_LOOKUPS L2,
142: MFG_LOOKUPS L3,
143: MFG_LOOKUPS L4
144: WHERE L1.LOOKUP_TYPE = 'BOM_INQUIRY_DISPLAY_TYPE'
145: AND L1.LOOKUP_CODE = P_EXPLODE_OPTION_TYPE
146: AND L2.LOOKUP_TYPE = 'MCG_AUTOLOAD_OPTION'
147: AND L2.LOOKUP_CODE = P_ALT_OPTION_TYPE

Line 163: MFG_LOOKUPS L1,

159: ,1
160: ,4)
161: INTO L_YES,L_NO
162: FROM
163: MFG_LOOKUPS L1,
164: MFG_LOOKUPS L2
165: WHERE L1.LOOKUP_TYPE = 'SYS_YES_NO'
166: AND L1.LOOKUP_CODE = 1
167: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'

Line 164: MFG_LOOKUPS L2

160: ,4)
161: INTO L_YES,L_NO
162: FROM
163: MFG_LOOKUPS L1,
164: MFG_LOOKUPS L2
165: WHERE L1.LOOKUP_TYPE = 'SYS_YES_NO'
166: AND L1.LOOKUP_CODE = 1
167: AND L2.LOOKUP_TYPE = 'SYS_YES_NO'
168: AND L2.LOOKUP_CODE = 2;

Line 737: MFG_LOOKUPS

733: SELECT
734: MEANING
735: INTO DUMMY
736: FROM
737: MFG_LOOKUPS
738: WHERE LOOKUP_TYPE = 'WIP_SUPPLY'
739: AND LOOKUP_CODE = WIP_SUPPLY_TYPE;
740: RETURN (DUMMY);
741: ELSE