eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INV_LABEL dependencies on WMS_BFLOW_LABEL_TYPE

Line 107: FROM wms_bflow_label_type wblt, mfg_lookups ml

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

Line 124: FROM wms_bflow_label_type wblt, mfg_lookups ml

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

Line 133: FROM wms_bflow_label_type wblt, mfg_lookups ml

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