[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
INVOICE_NUM
INTO L_INVOICE
FROM
AP_INVOICES_ALL
WHERE INVOICE_ID = C_INVOICE_ID
AND ROWNUM < 2;
SELECT
TRX_NUMBER
INTO L_INVOICE
FROM
RA_CUSTOMER_TRX_ALL
WHERE CUSTOMER_TRX_ID = C_INVOICE_ID
AND ROWNUM < 2;
SELECT
INVOICE_NUM
INTO L_INVOICE
FROM
AP_INVOICES_ALL
WHERE INVOICE_ID = C_INVOICE_ID
AND ROWNUM < 2;
SELECT
BATCH_NAME
INTO L_INVOICE_BATCH
FROM
AP_BATCHES_ALL
WHERE BATCH_ID = C_INVOICE_BATCH_ID
AND ROWNUM < 2;
SELECT
NAME
INTO L_INVOICE_BATCH
FROM
RA_BATCHES_ALL
WHERE BATCH_ID = C_INVOICE_BATCH_ID
AND ROWNUM < 2;
SELECT
LINE_NUMBER
INTO L_INVOICE_LINE
FROM
RA_CUSTOMER_TRX_LINES_ALL
WHERE CUSTOMER_TRX_LINE_ID = C_CUSTOMER_TRX_LINE_ID
AND ROWNUM < 2;
SELECT
UOM_CODE
INTO L_INVOICE_UOM_CODE
FROM
RA_CUSTOMER_TRX_LINES_ALL
WHERE CUSTOMER_TRX_LINE_ID = C_CUSTOMER_TRX_LINE_ID;
SELECT
RECEIPT_NUM
INTO L_RECEIPT_NUMBER
FROM
RCV_SHIPMENT_HEADERS
WHERE SHIPMENT_HEADER_ID = C_SHIPMENT_HEADER_ID
AND ROWNUM < 2;
SELECT
LINE_NUM
INTO L_SHIPMENT_LINE
FROM
RCV_SHIPMENT_LINES
WHERE SHIPMENT_LINE_ID = C_SHIPMENT_LINE_ID
AND ROWNUM < 2;
SELECT
SHIPMENT_NUM
INTO L_SHIPMENT_NUMBER
FROM
PO_LINE_LOCATIONS_ALL
WHERE LINE_LOCATION_ID = C_PO_LINE_LOCATION_ID
AND ROWNUM < 2;
SELECT
LINE_NUM
INTO L_SOURCE_LINE_NUMBER
FROM
PO_LINES_ALL
WHERE PO_LINE_ID = C_PO_LINE_ID
AND ROWNUM < 2;
SELECT
LINE_NUMBER
INTO L_SOURCE_LINE_NUMBER
FROM
OE_ORDER_LINES_ALL
WHERE LINE_ID = C_ORDER_LINE_ID
AND ROWNUM < 2;
SELECT
LINE_NUM
INTO L_SOURCE_LINE_NUMBER
FROM
PO_REQUISITION_LINES_ALL
WHERE REQUISITION_LINE_ID = C_REQUISITION_LINE_ID
AND ROWNUM < 2;
SELECT
LINE_NUMBER
INTO L_SOURCE_LINE_NUMBER
FROM
OE_ORDER_LINES_ALL
WHERE LINE_ID = C_ORDER_LINE_ID
AND ROWNUM < 2;
SELECT
SEGMENT1
INTO L_SOURCE_NUMBER
FROM
PO_HEADERS_ALL
WHERE PO_HEADER_ID = C_PO_HEADER_ID
AND ROWNUM < 2;
SELECT
ORDER_NUMBER
INTO L_SOURCE_NUMBER
FROM
OE_ORDER_HEADERS_ALL
WHERE HEADER_ID = C_ORDER_HEADER_ID
AND ROWNUM < 2;
SELECT
SEGMENT1
INTO L_SOURCE_NUMBER
FROM
PO_REQUISITION_HEADERS_ALL
WHERE REQUISITION_HEADER_ID = C_REQUISITION_HEADER_ID
AND ROWNUM < 2;
SELECT
ORDER_NUMBER
INTO L_SOURCE_NUMBER
FROM
OE_ORDER_HEADERS_ALL
WHERE HEADER_ID = C_ORDER_HEADER_ID
AND ROWNUM < 2;
SELECT
HP.PARTY_NAME
INTO L_TRADER_NAME
FROM
HZ_PARTIES HP,
HZ_CUST_ACCOUNTS HCA
WHERE HP.PARTY_ID = HCA.PARTY_ID
AND HCA.CUST_ACCOUNT_ID = C_SHIP_TO_CUSTOMER_ID;
SELECT
NAME
INTO L_TRADER_NAME
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = C_FROM_ORGANIZATION_ID
AND ROWNUM < 2;
SELECT
NAME
INTO L_TRADER_NAME
FROM
HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = C_TO_ORGANIZATION_ID
AND ROWNUM < 2;
SELECT
HCA.ACCOUNT_NUMBER
INTO L_TRADER_NUMBER
FROM
HZ_PARTIES HP,
HZ_CUST_ACCOUNTS HCA
WHERE HP.PARTY_ID = HCA.PARTY_ID
AND HCA.CUST_ACCOUNT_ID = C_SHIP_TO_CUSTOMER_ID;
SELECT
LOCATION
INTO L_TRADER_SITE
FROM
HZ_CUST_SITE_USES_ALL
WHERE SITE_USE_ID = C_SHIP_TO_SITE_USE_ID;
UPDATE
MTL_MOVEMENT_STATISTICS
SET
MOVEMENT_STATUS = 'F'
,REPORT_REFERENCE = TO_CHAR(P_LEGAL_ENTITY_ID) || P_ZONE_CODE || P_PERIOD_NAME || P_USAGE_TYPE || P_STAT_TYPE || P_MOVEMENT_TYPE
WHERE ENTITY_ORG_ID = P_LEGAL_ENTITY_ID
AND ZONE_CODE = P_ZONE_CODE
AND PERIOD_NAME = P_PERIOD_NAME
AND USAGE_TYPE = P_USAGE_TYPE
AND STAT_TYPE = P_STAT_TYPE
AND MOVEMENT_TYPE = P_MOVEMENT_TYPE
AND MOVEMENT_STATUS = 'V';
SELECT
PRECISION
INTO L_PRECISION_TRX
FROM
FND_CURRENCIES
WHERE CURRENCY_CODE = C_MOVEMENT_CURRENCY_CODE;
SELECT
PO_RELEASE_ID
INTO L_PO_RELEASE_ID
FROM
RCV_TRANSACTIONS
WHERE TRANSACTION_ID = C_RCV_TRANSACTION_ID;
SELECT
RELEASE_NUM
INTO L_RELEASE_NUM
FROM
PO_RELEASES_ALL
WHERE PO_RELEASE_ID = L_PO_RELEASE_ID;
SELECT
COUNT(*)
INTO
l_nnverified_status_count
FROM
MTL_MOVEMENT_STATISTICS mms
WHERE mms.entity_org_id = p_legal_entity_id
AND mms.zone_code = p_zone_code
AND mms.period_name = p_period_name
AND mms.usage_type = p_usage_type
AND mms.stat_type = p_stat_type
AND mms.movement_type = p_movement_type
AND movement_status = 'O';
SELECT
frv.responsibility_name
, TO_CHAR(fcr.request_date, 'YYYY/MM/DD HH24:MI:SS')
, fav.application_name
, fu.user_name
INTO
cp_responsibility
, cp_request_time
, cp_application
, cp_requested_by
FROM
fnd_concurrent_requests fcr
, fnd_responsibility_vl frv
, fnd_application_vl fav
, fnd_user fu
WHERE fcr.request_id = p_conc_request_id
AND fcr.responsibility_application_id = frv.application_id
AND fcr.responsibility_id = frv.responsibility_id
AND frv.application_id = fav.application_id
AND fu.user_id = fcr.requested_by;
SELECT
TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI')
INTO
CP_SYSDATE
FROM
DUAL;
SELECT
gllv.legal_entity_name, hl.address_line_1,
hl.address_line_2, hl.address_line_3,
hl.telephone_number_1, hl.telephone_number_2,
ppf.full_name, -- hle.vat_registration_number,
gllv.ledger_name
INTO
CP_LEGAL_ENTITY_NAME, CP_ENTITY_ADDRESS_LINE_1,
CP_ENTITY_ADDRESS_LINE_2, CP_ENTITY_ADDRESS_LINE_3,
CP_TELEPHONE_NUMBER_1, CP_TELEPHONE_NUMBER_2,
CP_CONTACT_PERSON_NAME, --CP_VAT_REGISTRATION_NUMBER,
CP_SET_OF_BOOKS_NAME
FROM
hr_locations_no_join hl,
per_people_f ppf,
gl_ledger_le_v gllv
WHERE gllv.legal_entity_id = P_LEGAL_ENTITY_ID
AND gllv.ledger_category_code = 'PRIMARY'
AND gllv.location_id = hl.location_id
AND hl.designated_receiver_id = ppf.person_id(+)
AND rownum < 2;
SELECT
nvl(fc.extended_precision,1)
, nvl(fc.precision,1)
INTO
CP_EXT_PRECISION_FUNC
, CP_PRECISION_FUNC
FROM
fnd_currencies fc
WHERE fc.currency_code = P_CURRENCY_CODE
AND rownum < 2;
SELECT
tax_office_name
, weight_uom_code
, tax_office_location_id
INTO
CP_TAX_OFFICE_NAME
, CP_STANDARD_UOM
, l_location_id
FROM
mtl_stat_type_usages
WHERE legal_entity_id = P_LEGAL_ENTITY_ID
AND zone_code = P_ZONE_CODE
AND stat_type = P_STAT_TYPE
AND usage_type = P_USAGE_TYPE;
SELECT
address_line_1
, address_line_2
, address_line_3
INTO
CP_TAX_OFFICE_ADDRESS_LINE_1
, CP_TAX_OFFICE_ADDRESS_LINE_2
, CP_TAX_OFFICE_ADDRESS_LINE_3
FROM
hr_locations_no_join
WHERE location_id = l_location_id;
SELECT
address1
, address2
, address3
INTO
CP_TAX_OFFICE_ADDRESS_LINE_1
, CP_TAX_OFFICE_ADDRESS_LINE_2
, CP_TAX_OFFICE_ADDRESS_LINE_3
FROM
hz_locations
WHERE location_id = l_location_id;
SELECT
start_date
, end_date
INTO
CP_start_date
, CP_end_date
FROM
GL_PERIODS
WHERE period_name = P_period_name
AND rownum < 2;
SELECT
mcs.structure_id
INTO
PLEX_COMMODITY_STRUCT_NUM
FROM
mtl_stat_type_usages mstu
,mtl_category_sets mcs
WHERE mstu.legal_entity_id = P_LEGAL_ENTITY_ID
AND mstu.zone_code = P_ZONE_CODE
AND mstu.category_set_id = mcs.category_set_id
AND rownum < 2;
MODE="SELECT"
DISPLAY="ALL"
TABLEALIAS="MSI"');
MODE="SELECT"
DISPLAY="ALL"
TABLEALIAS="MC"');
SELECT zone_display_name
INTO cp_zone_name_cov
FROM mtl_economic_zones_vl
WHERE zone_code = p_zone_code
AND rownum<2;
SELECT meaning
INTO cp_rep_option_cov
FROM fnd_lookup_values
WHERE lookup_type = 'INTRASTAT_REPORT_OPTION'
AND lookup_code = p_report_option
AND enabled_flag = 'Y'
AND language = userenv('LANG')
AND rownum<2;
SELECT meaning
INTO cp_mv_type_cov
FROM fnd_lookups
WHERE lookup_type = 'MVT_MOVEMENT_TYPE'
AND lookup_code = p_movement_type
AND enabled_flag = 'Y'
AND rownum<2;
SELECT meaning
INTO cp_usage_type_cov
FROM fnd_lookups
WHERE lookup_type = 'MVT_USAGE_TYPES'
AND lookup_code = p_usage_type
AND enabled_flag = 'Y'
AND rownum<2;
SELECT meaning
INTO cp_stat_type_cov
FROM fnd_lookups
WHERE lookup_type = 'MVT_STAT_TYPES'
AND lookup_code = p_stat_type
AND enabled_flag = 'Y'
AND rownum<2;
P_MVT_ID_WHERE :='and movement_id = (select min(movement_id)
from mtl_movement_statistics
where parent_movement_id = mms.parent_movement_id
and movement_type = '''||P_MOVEMENT_TYPE||''' group by mms.parent_movement_id)';