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_STATUS_LOVS dependencies on MTL_STATUS_TRANSACTION_CONTROL

Line 111: and not exists ( select 1 from mtl_status_transaction_control mstc

107: FROM mtl_material_statuses_vl mms
108: WHERE mms.onhand_control = 1
109: and mms.enabled_flag = 1
110: and mms.status_code like (p_status_code)
111: and not exists ( select 1 from mtl_status_transaction_control mstc
112: where mms.status_id = mstc.status_id
113: and mstc.is_allowed = 2
114: and mstc.transaction_type_id = p_trx_type_id )
115: order by mms.status_code;

Line 133: and not exists ( select 1 from mtl_status_transaction_control mstc

129: FROM mtl_material_statuses_vl mms
130: WHERE mms.lot_control = 1
131: and mms.enabled_flag = 1
132: and mms.status_code like (p_status_code)
133: and not exists ( select 1 from mtl_status_transaction_control mstc
134: where mms.status_id = mstc.status_id
135: and mstc.is_allowed = 2
136: and mstc.transaction_type_id = p_trx_type_id )
137: order by mms.status_code;

Line 166: and not exists ( select 1 from mtl_status_transaction_control mstc

162: FROM mtl_material_statuses_vl mms
163: WHERE mms.serial_control = 1
164: and mms.enabled_flag = 1
165: and mms.status_code like (p_status_code)
166: and not exists ( select 1 from mtl_status_transaction_control mstc
167: where mms.status_id = mstc.status_id
168: and mstc.is_allowed = 2
169: and mstc.transaction_type_id = p_trx_type_id )
170: order by mms.status_code;