APPS.PO_RELGEN_PKG dependencies on MTL_SUPPLY

Line 1933: DELETE FROM MTL_SUPPLY

1929: BEGIN
1930:
1931: if (x_authorization_status = 'APPROVED') THEN
1932:
1933: DELETE FROM MTL_SUPPLY
1934: WHERE SUPPLY_TYPE_CODE = 'REQ'
1935: AND SUPPLY_SOURCE_ID = req_line.requisition_line_id;
1936:
1937: INSERT INTO MTL_SUPPLY

Line 1937: INSERT INTO MTL_SUPPLY

1933: DELETE FROM MTL_SUPPLY
1934: WHERE SUPPLY_TYPE_CODE = 'REQ'
1935: AND SUPPLY_SOURCE_ID = req_line.requisition_line_id;
1936:
1937: INSERT INTO MTL_SUPPLY
1938: (supply_type_code,
1939: supply_source_id,
1940: last_updated_by,
1941: last_update_date,

Line 1997: from mtl_supply ms1

1993: and pol.po_line_id = pod.po_line_id
1994: and nvl(poll.approved_flag, 'Y') = 'Y'
1995: and not exists
1996: (select 'Supply Exists'
1997: from mtl_supply ms1
1998: where ms1.supply_type_code = 'PO'
1999: and ms1.supply_source_id = pod.po_distribution_id);
2000:
2001: END IF;