DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on WMS_BFLOW_LABEL_TYPE

Line 106: FROM wms_bflow_label_type wblt, mfg_lookups ml

102: wblt.level_type_code level_type_code
103: -- Bug 3836484. The following literal is not good for performance
104: -- Remove the following since it is only used for trace message
105: -- , decode(wblt.level_type_code,10001,'Site',10002,'Application',10003,'Responsibility',10004,'User') level_type_name
106: FROM wms_bflow_label_type wblt, mfg_lookups ml
107: WHERE wblt.business_flow_code = p_business_flow
108: AND wblt.level_value_id =
109: decode(wblt.level_type_code, 10001,0,10002,FND_GLOBAL.RESP_APPL_ID
110: ,10003,FND_GLOBAL.RESP_ID,10004, FND_GLOBAL.USER_ID)

Line 123: FROM wms_bflow_label_type wblt, mfg_lookups ml

119: Cursor sel_lab is
120: SELECT wblt.document_id label_type_id,
121: ml.meaning label_type_name,
122: wblt.level_type_code level_type_code
123: FROM wms_bflow_label_type wblt, mfg_lookups ml
124: WHERE wblt.business_flow_code = 22
125: AND nvl(wblt.enabled_flag, 'N') = 'Y'
126: AND ml.lookup_type = 'WMS_LABEL_TYPE'
127: AND ml.lookup_code = wblt.document_id

Line 132: FROM wms_bflow_label_type wblt, mfg_lookups ml

128: MINUS
129: SELECT wblt.document_id label_type_id,
130: ml.meaning label_type_name,
131: wblt.level_type_code level_type_code
132: FROM wms_bflow_label_type wblt, mfg_lookups ml
133: WHERE wblt.business_flow_code = 42
134: AND nvl(wblt.enabled_flag, 'N') = 'Y'
135: AND ml.lookup_type = 'WMS_LABEL_TYPE'
136: AND ml.lookup_code = wblt.document_id