[Home] [Help]
87:
88: IF (p_trx_type_id IS NOT NULL) THEN
89: OPEN x_status FOR
90: SELECT mms.status_code, mms.status_id
91: FROM mtl_material_statuses_vl mms, mtl_status_transaction_control mstc
92: WHERE mms.status_id = mstc.status_id
93: and mms.lot_control = 1
94: and mms.enabled_flag = 1
95: and mms.status_code like (p_status_code)