APPS.MRP_VENDORMERGE_GRP dependencies on MRP_SR_RECEIPT_ORG

Line 26: TYPE t_sr_receipt_id IS TABLE OF mrp_sr_receipt_org.sr_receipt_id%TYPE;

22:
23: l_api_name CONSTANT VARCHAR2(30) := 'Merge_Vendor';
24: l_api_version CONSTANT NUMBER := 1.0;
25: l_row_count NUMBER;
26: TYPE t_sr_receipt_id IS TABLE OF mrp_sr_receipt_org.sr_receipt_id%TYPE;
27: l_sr_receipt_id t_sr_receipt_id;
28: l_sourcing_rule_name mrp_sourcing_rules.sourcing_rule_name%TYPE;
29:
30: CURSOR c1(receipt_id NUMBER) IS

Line 127: FROM mrp_sr_receipt_org

123: IF c1%FOUND THEN
124: UPDATE mrp_sourcing_rules
125: SET planning_active = 2
126: WHERE sourcing_rule_id = ( SELECT sourcing_rule_id
127: FROM mrp_sr_receipt_org
128: WHERE sr_receipt_id = l_sr_receipt_id(j))
129: AND planning_active = 1
130: RETURNING sourcing_rule_name INTO l_sourcing_rule_name;
131: