DBA Data[Home] [Help]

APPS.BOM_BOMRBOMS_XMLP_PKG dependencies on MFG_LOOKUPS

Line 137: MFG_LOOKUPS L1,

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

Line 138: MFG_LOOKUPS L2,

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

Line 139: MFG_LOOKUPS L3,

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

Line 140: MFG_LOOKUPS L4

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

Line 160: MFG_LOOKUPS L1,

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

Line 161: MFG_LOOKUPS L2

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

Line 666: MFG_LOOKUPS

662: SELECT
663: MEANING
664: INTO DUMMY
665: FROM
666: MFG_LOOKUPS
667: WHERE LOOKUP_TYPE = 'WIP_SUPPLY'
668: AND LOOKUP_CODE = WIP_SUPPLY_TYPE;
669: RETURN (DUMMY);
670: ELSE