[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT porl.item_id,
porl.item_revision,
porl.item_description,
porl.category_id,
porl.unit_meas_lookup_code,
porl.unit_price,
porl.vendor_id,
porl.vendor_site_id,
porl.vendor_contact_id,
porl.suggested_vendor_product_code,
porl.suggested_buyer_id,
nvl(porl.source_type_code, 'VENDOR'),
porl.source_organization_id,
porl.source_subinventory,
porl.line_type_id,
porl.rfq_required_flag,
porl.vendor_source_context,
porl.org_id,
plt.line_type,
plt.order_type_lookup_code,
plc.displayed_field,
po_inq_sv.get_person_name(porl.suggested_buyer_id),
nvl(v.vendor_name,porl.suggested_vendor_name),
decode (vc.last_name, NULL, porl.suggested_vendor_contact, vc.last_name||', '||vc.first_name),
nvl(vs.vendor_site_code,porl.suggested_vendor_location),
ood.organization_name,
porl.amount,
porl.negotiated_by_preparer_flag
INTO x_item_id,
x_item_revision,
x_item_description,
x_category_id,
x_unit_meas_lookup_code,
x_unit_price,
x_vendor_id,
x_vendor_site_id,
x_vendor_contact_id,
x_vendor_product_code,
x_suggested_buyer_id,
x_source_type_code,
x_source_organization_id,
x_source_subinventory,
x_line_type_id,
x_rfq_required_flag,
x_vendor_source_context,
x_org_id, -- debug
x_line_type,
x_order_type_lookup_code,
x_source_type,
x_suggested_buyer,
x_vendor_name,
x_vendor_contact,
x_vendor_site,
x_source_organization_name,
x_amount,
x_negotiated_by_preparer_flag
FROM po_lookup_codes plc,
org_organization_definitions ood,
po_line_types plt,
po_vendor_contacts vc,
po_vendor_sites vs,
po_vendors v,
mtl_system_items msi,
po_requisition_lines porl
WHERE porl.rowid = x_rowid
AND nvl(porl.cancel_flag,'N') = 'N'
AND nvl(porl.closed_code,'OPEN') <> 'FINALLY CLOSED'
AND porl.item_id = msi.inventory_item_id (+)
AND msi.organization_id (+) = x_inv_org_id
AND nvl(msi.outside_operation_flag,'N') = 'N'
AND plt.line_type_id = porl.line_type_id
AND plc.lookup_type (+) = 'REQUISITION SOURCE TYPE'
AND plc.lookup_code (+) = porl.source_type_code
AND v.vendor_id (+) = porl.vendor_id
AND vc.vendor_contact_id (+) = porl.vendor_contact_id
AND vs.vendor_site_id (+) = porl.vendor_site_id
AND ood.organization_id(+) = porl.source_organization_id;
SELECT 'Y'
INTO dummy_char
FROM po_reqexpress_headers porh
WHERE porh.express_name = x_express_name;
SELECT 1
INTO dummy
FROM DUAL
WHERE not exists (SELECT 'this line num exists already'
FROM PO_REQEXPRESS_LINES
WHERE EXPRESS_NAME = X_express_name
AND SEQUENCE_NUM = X_sequence_num
AND (rowid <> X_rowid OR X_rowid is NULL));
SELECT item_cost
INTO x_unit_price
FROM cst_item_costs_for_gl_view
WHERE inventory_item_id = x_inventory_item_id
AND organization_id = x_organization_id;
SELECT primary_unit_of_measure
INTO x_primary_unit_of_measure
FROM mtl_system_items
WHERE inventory_item_id = x_inventory_item_id
AND organization_id = x_organization_id;
SELECT order_type_lookup_code
INTO x_order_type_lookup_code
FROM po_line_types
WHERE line_type_id = x_line_type_id;