[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DECODE(FPG.MULTI_ORG_FLAG,
'Y',
DECODE(HOI.ORG_INFORMATION_CONTEXT, 'Accounting Information', TO_NUMBER(HOI.ORG_INFORMATION3), TO_NUMBER(NULL)),
TO_NUMBER(NULL)
) OPERATING_UNIT
INTO x_org_id
FROM HR_ORGANIZATION_INFORMATION HOI,
FND_PRODUCT_GROUPS FPG
WHERE HOI.ORGANIZATION_ID = p_organization_id
AND ( HOI.ORG_INFORMATION_CONTEXT || '') ='Accounting Information';
SELECT organization_id
INTO x_org_id
FROM hr_organization_units
WHERE NAME = p_ou;
SELECT NAME
INTO x_ou
FROM hr_organization_units
WHERE organization_id = p_org_id;
SELECT acct.cust_account_id
INTO x_customer_id
FROM hz_parties party,
hz_cust_accounts acct
WHERE party.party_id = acct.party_id
AND party.party_name = p_customer_party_name
AND acct.account_number = p_customer_account_number;
SELECT party.party_name
INTO x_customer_party_name
FROM hz_parties party,
hz_cust_accounts acct
WHERE party.party_id = acct.party_id
AND acct.cust_account_id = p_customer_id;
SELECT acct.account_number
INTO x_customer_account_number
FROM hz_cust_accounts acct
WHERE acct.cust_account_id = p_customer_id;
SELECT employee_id
INTO x_employee_id
FROM hr_employees
WHERE full_name = p_employee_name;
SELECT full_name
INTO x_employee_name
FROM hr_employees
WHERE employee_id = p_employee_id;
SELECT organization_id
INTO x_org_id
FROM mtl_parameters
WHERE organization_code = p_org_code;
SELECT org.organization_id
INTO x_org_id
FROM hr_locations hl,
mtl_parameters org
WHERE hl.location_id = p_location_id
AND hl.inventory_organization_id = org.organization_id;
SELECT location_id
INTO x_location_id
FROM hr_locations_all
WHERE location_code = p_location_code
AND ( business_group_id = NVL(hr_general.get_business_group_id, business_group_id)
OR business_group_id IS NULL);
SELECT term_id
INTO x_payment_terms_id
FROM ap_terms
WHERE NAME = p_payment_terms_name;
SELECT vendor_id
INTO x_vendor_id
FROM po_vendors
WHERE vendor_name = p_vendor_name;
SELECT vendor_id
INTO x_vendor_id
FROM po_vendors
WHERE segment1 = p_vendor_num;
SELECT vendor_site_id,
vendor_id
INTO x_vendor_site_id,
x_vendor_id
FROM po_vendor_sites_all
WHERE org_id = NVL(p_org_id, org_id)
AND vendor_site_code = p_vendor_site_code
AND vendor_id = NVL(p_vendor_id, vendor_id);
SELECT vendor_site_code,
vendor_id
INTO x_vendor_site_code,
x_vendor_id
FROM po_vendor_sites
WHERE org_id = NVL(p_org_id, org_id)
AND vendor_site_id = p_vendor_site_id;
SELECT max(hps.location_id)
INTO x_ship_from_location_id
FROM hz_party_sites hps,
hz_party_site_uses hpsu,
po_vendor_sites_all pvs
WHERE pvs.vendor_site_id = p_vendor_site_id
AND hpsu.party_site_id = hps.party_site_id
AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
AND hps.party_site_number = p_ship_from_location_code||'|'||hps.party_id
AND hps.party_site_number like p_ship_from_location_code||'%'; --Bug 5200786.
SELECT customer_item_id
INTO x_customer_item_id
FROM mtl_customer_items
WHERE customer_item_number = p_customer_item_num
AND customer_id = p_customer_id;
SELECT customer_item_number
INTO x_customer_item_num
FROM mtl_customer_items
WHERE customer_item_id = p_customer_item_id;
SELECT inventory_item_id
INTO x_item_id
FROM mtl_item_flexfields
WHERE organization_id = p_org_id
AND description = p_item_description;
SELECT inventory_item_id
INTO x_item_id
FROM mtl_item_flexfields
WHERE organization_id = p_org_id
AND item_number = p_item_num;
SELECT description
INTO x_item_description
FROM mtl_system_items_vl --5504176
WHERE organization_id = p_org_id
AND inventory_item_id = p_item_id;
SELECT item_number
INTO x_item_num
FROM mtl_item_flexfields
WHERE organization_id = p_org_id
AND inventory_item_id = p_item_id;
SELECT unit_of_measure
INTO x_unit_of_measure
FROM mtl_units_of_measure
WHERE uom_code = p_uom_code;
SELECT uom_code
INTO x_uom_code
FROM mtl_units_of_measure
WHERE unit_of_measure = p_unit_of_measure;
SELECT inventory_location_id
INTO x_locator_id
FROM mtl_item_locations_kfv
WHERE organization_id = p_org_id
AND concatenated_segments = p_locator
AND ( subinventory_code = NVL(p_subinventory, subinventory_code)
OR subinventory_code IS NULL)
AND ( disable_date > SYSDATE
OR disable_date IS NULL);
SELECT concatenated_segments
INTO x_locator
FROM mtl_item_locations_kfv
WHERE organization_id = p_org_id
AND inventory_location_id = p_locator_id
AND ( subinventory_code = NVL(p_subinventory, subinventory_code)
OR subinventory_code IS NULL)
AND ( disable_date > SYSDATE
OR disable_date IS NULL);
SELECT routing_header_id
INTO x_routing_header_id
FROM rcv_routing_headers
WHERE routing_name = p_routing_code;
SELECT routing_step_id
INTO x_routing_step_id
FROM rcv_routing_steps
WHERE step_name = p_routing_step;
SELECT wip_entity_id
INTO x_wip_entity_id
FROM wip_entities
WHERE organization_id = p_org_id
AND wip_entity_name = p_wip_entity_name;
SELECT wip_entity_name
INTO x_wip_entity_name
FROM wip_entities
WHERE organization_id = p_org_id
AND wip_entity_id = p_wip_entity_id;
rcv_table_functions.update_rhi_row(rhi);
IF (rti.program_update_date IS NULL) THEN
rti.program_update_date := prti.program_update_date;
SELECT source_line_id
FROM mtl_material_transactions
WHERE source_code = 'ORDER ENTRY'
AND transaction_id = p_mmt_transaction_id;*/
select nvl(poll.price_override,pol.unit_price)
into pll.price_override
from po_line_locations_all poll,
po_lines_all pol
where poll.line_location_id = pll.line_location_id
and pol.po_line_id = poll.po_line_id;
select nvl(poll.description,pol.item_description)
into pll.description
from po_line_locations_all poll,
po_lines_all pol
where poll.line_location_id = pll.line_location_id
and pol.po_line_id = poll.po_line_id;
SELECT rcv_headers_interface_s.NEXTVAL
INTO rti.header_interface_id
FROM DUAL;
INSERT INTO rcv_headers_interface
(created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
attribute_category,
attribute1,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
auto_transact_code,
bill_of_lading,
comments,
currency_code,
conversion_rate_date,
conversion_rate,
conversion_rate_type,
customer_account_number,
customer_id,
customer_party_name,
customer_site_id,
employee_id,
expected_receipt_date,
freight_carrier_code,
from_organization_code,
from_organization_id,
GROUP_ID,
header_interface_id,
location_code,
location_id,
num_of_containers,
packing_slip,
processing_request_id,
processing_status_code,
receipt_source_code,
receipt_header_id,
receipt_num,
shipment_num,
shipped_date,
tax_amount,
tax_name,
ship_to_organization_code,
ship_to_organization_id,
org_id,
operating_unit,
transaction_type,
test_flag,
usggl_transaction_code,
validation_flag,
vendor_id,
vendor_name,
vendor_num,
vendor_site_code,
vendor_site_id,
waybill_airbill_num
)
VALUES (rti.created_by,
rti.creation_date,
rti.last_updated_by,
rti.last_update_date,
rti.last_update_login,
rti.attribute_category,
rti.attribute1,
rti.attribute10,
rti.attribute11,
rti.attribute12,
rti.attribute13,
rti.attribute14,
rti.attribute15,
rti.attribute2,
rti.attribute3,
rti.attribute4,
rti.attribute5,
rti.attribute6,
rti.attribute7,
rti.attribute8,
rti.attribute9,
rti.auto_transact_code,
rti.bill_of_lading,
rti.comments,
rti.currency_code,
rti.currency_conversion_date,
rti.currency_conversion_rate,
rti.currency_conversion_type,
rti.customer_account_number,
rti.customer_id,
rti.customer_party_name,
rti.customer_site_id,
rti.employee_id,
rti.expected_receipt_date,
rti.freight_carrier_code,
rti.from_organization_code,
rti.from_organization_id,
rti.GROUP_ID,
rti.header_interface_id,
rti.location_code,
rti.location_id,
rti.num_of_containers,
rti.packing_slip,
rti.processing_request_id,
rti.processing_status_code,
rti.receipt_source_code,
rti.shipment_header_id,
x_receipt_num,
rti.shipment_num,
rti.shipped_date,
rti.tax_amount,
rti.tax_name,
rti.to_organization_code,
rti.to_organization_id,
rti.org_id,
rti.operating_unit,
'NEW',
'Y',
rti.ussgl_transaction_code,
rti.validation_flag,
rti.vendor_id,
rti.vendor_name,
rti.vendor_num,
rti.vendor_site_code,
rti.vendor_site_id,
rti.waybill_airbill_num
);
SELECT lot_control_code,
serial_number_control_code
INTO rti.use_mtl_lot,
rti.use_mtl_serial
FROM mtl_system_items
WHERE mtl_system_items.inventory_item_id = rti.item_id
AND mtl_system_items.organization_id = rti.to_organization_id;