APPS.PO_RELGEN_PKG dependencies on MTL_SUPPLY

Line 1908: DELETE FROM MTL_SUPPLY

1904: BEGIN
1905:
1906: if (x_authorization_status = 'APPROVED') THEN
1907:
1908: DELETE FROM MTL_SUPPLY
1909: WHERE SUPPLY_TYPE_CODE = 'REQ'
1910: AND SUPPLY_SOURCE_ID = req_line.requisition_line_id;
1911:
1912: INSERT INTO MTL_SUPPLY

Line 1912: INSERT INTO MTL_SUPPLY

1908: DELETE FROM MTL_SUPPLY
1909: WHERE SUPPLY_TYPE_CODE = 'REQ'
1910: AND SUPPLY_SOURCE_ID = req_line.requisition_line_id;
1911:
1912: INSERT INTO MTL_SUPPLY
1913: (supply_type_code,
1914: supply_source_id,
1915: last_updated_by,
1916: last_update_date,

Line 1972: from mtl_supply ms1

1968: and pol.po_line_id = pod.po_line_id
1969: and nvl(poll.approved_flag, 'Y') = 'Y'
1970: and not exists
1971: (select 'Supply Exists'
1972: from mtl_supply ms1
1973: where ms1.supply_type_code = 'PO'
1974: and ms1.supply_source_id = pod.po_distribution_id);
1975:
1976: END IF;