APPS.GMI_ALLOCATION_RULES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

SELECT cust_id
FROM op_cust_mst
WHERE co_code = p_co_code and cust_no = p_cust_no;

Line: 60

SELECT *
FROM op_alot_prm
WHERE cust_id=l_cust_id and alloc_class = p_alloc_class and delete_mark=0;

Line: 65

SELECT *
FROM op_alot_prm
WHERE cust_id IS NULL and alloc_class = p_alloc_class and delete_mark=0;

Line: 74

SELECT *
FROM op_alot_prm
WHERE sold_to_org_id = p_of_cust_id
  --and ship_to_org_id = p_ship_to_org_id
  and org_id = p_org_id
  and alloc_class = p_alloc_class
  and delete_mark=0;

Line: 82

SELECT *
FROM op_alot_prm
WHERE sold_to_org_id IS NULL
  and org_id  is null
  and alloc_class = p_alloc_class
  and delete_mark=0;