DBA Data[Home] [Help]

APPS.GML_AUTO_ALLOC dependencies on OP_ALOT_PRM

Line 191: FROM op_alot_prm

187: V_partial_ind IN OUT NOCOPY NUMBER, V_prefqc_grade IN OUT NOCOPY VARCHAR2) IS
188: CURSOR Cur_qry_allocation(V_cust_id NUMBER) IS
189: SELECT alloc_method, shelf_days, alloc_horizon,
190: alloc_type, lot_qty, partial_ind, prefqc_grade
191: FROM op_alot_prm
192: WHERE NVL(cust_id,0) = V_cust_id -- This enables us to open
193: -- the cursor when V_cust_id is null
194: AND alloc_class = V_alloc_class
195: AND delete_mark = 0;