[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ato_line_id
INTO l_ato_line_id_cogs
FROM oe_order_lines_all
WHERE line_id=l_line_id;
SELECT ato_line_id
INTO l_ato_line_id_rev
FROM oe_order_lines_all
WHERE line_id=x_revenue_event_line_id;
SELECT 'Y' INTO l_notify_costing
FROM DUAL WHERE EXISTS (SELECT l.line_id
FROM oe_order_lines_all l,
mtl_system_items msi
WHERE link_to_line_id = p_line_id
AND l.inventory_item_id=msi.inventory_item_id
AND msi.organization_id= l_master_org_id
AND (msi.invoice_enabled_flag = 'N'
OR msi.invoiceable_item_flag = 'N'
OR l.item_type_code='INCLUDED'
OR l.item_type_code='CONFIG'));
SELECT 'Y' INTO l_inventory_interfaced
FROM WF_ITEM_ACTIVITY_STATUSES WAS, WF_PROCESS_ACTIVITIES WPA
WHERE WAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
AND WAS.ITEM_TYPE = 'OEOL'
AND WAS.ITEM_KEY = to_char(p_line_id)
AND WPA.ACTIVITY_NAME = 'INVENTORY_INTERFACE'
AND WAS.ACTIVITY_STATUS = 'COMPLETE'
AND WAS.ACTIVITY_RESULT_CODE = 'COMPLETE';