[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_cust_query VARCHAR2(15000) := 'SELECT line_id '||
', header_id '||
', item_type_code '||
', flow_status_code '||
', actual_shipment_date '||
', service_reference_type_code '||
', service_reference_line_id '||
', top_model_line_id '||
', contingency_id '||
', accepted_quantity '||
', sold_to_org_id '||
', revrec_expiration_days';
SELECT ou.organization_id
FROM hr_operating_units ou
WHERE mo_global.check_access(ou.organization_id) = 'Y';
l_cust_query VARCHAR2(15000) := 'SELECT oel.line_id '||
', oel.header_id '||
', oel.item_type_code '||
', oel.flow_status_code '||
', oel.actual_shipment_date '||
', oel.service_reference_type_code '||
', oel.service_reference_line_id '||
', oel.top_model_line_id '||
', oel.contingency_id '||
', oel.accepted_quantity '||
', oel.sold_to_org_id '||
', oel.revrec_expiration_days ';
SELECT count(*)
INTO l_count
FROM oe_order_lines_all
WHERE header_id = l_header_id
AND top_model_line_id = l_line_id
AND flow_status_code NOT IN ('PRE-BILLING_ACCEPTANCE') --myerrams, Bug: 5290313
AND nvl(open_flag, 'Y') = 'Y';
SELECT max(actual_shipment_date)
INTO l_max_actual_shipment_date
FROM oe_order_lines_all
WHERE header_id = l_header_id
AND top_model_line_id = l_line_id;
SELECT line_id
, contingency_id
, revrec_event_code
, accepted_quantity
INTO l_line_id
, l_contingency_id
, l_revrec_event_code
, l_accepted_quantity
FROM oe_order_lines_all
WHERE line_id = l_product_line_id;