[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
USERENV('LANG')
INTO P_USER_LANG
FROM
DUAL;
SELECT
PRECISION
INTO W_PRECISION
FROM
FND_CURRENCIES
WHERE CURRENCY_CODE = CURRENCY1;
SQLSTMT := 'select multi_lingual_flag
into :mls_flag
from fnd_product_groups
where multi_lingual_flag = ''Y''';
SELECT
SUBSTR(USERENV('LANGUAGE')
,1
,INSTR(USERENV('LANGUAGE')
,'_') - 1)
INTO SESSION_LANGUAGE
FROM
DUAL;
SELECT
NLS_LANGUAGE
INTO BASE_LANGUAGE
FROM
FND_LANGUAGES
WHERE INSTALLED_FLAG = 'B';
SQLSTMT := 'select alax.attribute_column_name
into :att_column_name
from ak_translated_columns atc,
ak_language_attribute_xrefs alax
where atc.table_name = ' || '''MTL_UNITS_OF_MEASURE''' || ' and atc.column_name = ' || '''UNIT_OF_MEASURE''' || ' and alax.translated_column_number = atc.translated_column_number
and alax.language = ' || '''' || SESSION_LANGUAGE || '''';
SELECT
CURRENCY_CODE
INTO BASE_CURRENCY
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = P_SOB_ID;
SELECT
C_GL_CONV_RATE * NVL(SVC_EXTENDED_PRICE
,0)
INTO FC_SVC_EXTENDED_PRICE
FROM
DUAL;
SELECT
C_GL_CONV_RATE * SVC_SELLING_PRICE
INTO FC_SVC_SELLING_PRICE
FROM
DUAL;
SELECT
NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
,MO_GLOBAL.GET_CURRENT_ORG_ID)
,0)
INTO V_MASTER_ORG
FROM
DUAL;
SELECT
UNIT_OF_MEASURE
INTO L_PERIODICITY
FROM
MTL_UNITS_OF_MEASURE_VL
WHERE UOM_CODE = CHARGE_PERIODICITY_CODE
AND UOM_CLASS = FND_PROFILE.VALUE('ONT_UOM_CLASS_CHARGE_PERIODICITY');
SELECT
PRECISION
INTO W_PRECISION
FROM
FND_CURRENCIES
WHERE CURRENCY_CODE = CURRENCY1;
SELECT
SUM(NVL(CHARGE_AMOUNT
,0))
INTO L_HEADER_CHARGE
FROM
OE_CHARGE_LINES_V
WHERE HEADER_ID =C_HEADER_CHARGEFORMULA.HEADER_ID
AND LINE_ID is null;
SELECT
MEANING
INTO L_RETURN_VALUE
FROM
OE_LOOKUPS
WHERE LOOKUP_TYPE = 'OM_YES_NO'
AND LOOKUP_CODE = 'NO';
SELECT
MEANING
INTO L_RETURN_VALUE
FROM
OE_LOOKUPS
WHERE LOOKUP_TYPE = 'OM_YES_NO'
AND LOOKUP_CODE = 'YES';
SELECT
SUBSTRB(BILL_CT_PARTY.PERSON_FIRST_NAME
,1
,40) || ' ' || SUBSTRB(BILL_CT_PARTY.PERSON_LAST_NAME
,1
,50)
INTO L_BILL_CONTACT
FROM
HZ_CUST_ACCOUNT_ROLES BILL_CT_ACCT_ROLE,
HZ_PARTIES BILL_CT_PARTY,
HZ_RELATIONSHIPS BILL_CT_REL,
HZ_ORG_CONTACTS BILL_CT_ORG_CONT,
HZ_PARTIES BILL_CT_REL_PARTY,
HZ_CUST_ACCOUNTS BILL_CT_ROLE_ACCT
WHERE BILL_CT_ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = INVOICE_TO_CONTACT_ID
AND BILL_CT_ACCT_ROLE.PARTY_ID = BILL_CT_REL.PARTY_ID
AND BILL_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND BILL_CT_REL.RELATIONSHIP_ID = BILL_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
AND BILL_CT_REL.SUBJECT_ID = BILL_CT_PARTY.PARTY_ID
AND BILL_CT_REL.PARTY_ID = BILL_CT_REL_PARTY.PARTY_ID
AND BILL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND BILL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND BILL_CT_ACCT_ROLE.CUST_ACCOUNT_ID = BILL_CT_ROLE_ACCT.CUST_ACCOUNT_ID
AND BILL_CT_ROLE_ACCT.PARTY_ID = BILL_CT_REL.OBJECT_ID;
SELECT
SUBSTRB(SHIP_CT_PARTY.PERSON_FIRST_NAME
,1
,40) || ' ' || SUBSTRB(SHIP_CT_PARTY.PERSON_LAST_NAME
,1
,50)
INTO L_SHIP_CONTACT
FROM
HZ_CUST_ACCOUNT_ROLES SHIP_CT_ACCT_ROLE,
HZ_PARTIES SHIP_CT_PARTY,
HZ_RELATIONSHIPS SHIP_CT_REL,
HZ_ORG_CONTACTS SHIP_CT_ORG_CONT,
HZ_PARTIES SHIP_CT_REL_PARTY,
HZ_CUST_ACCOUNTS SHIP_CT_ROLE_ACCT
WHERE SHIP_CT_ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
AND SHIP_CT_ACCT_ROLE.PARTY_ID = SHIP_CT_REL.PARTY_ID
AND SHIP_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND SHIP_CT_REL.RELATIONSHIP_ID = SHIP_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
AND SHIP_CT_REL.SUBJECT_ID = SHIP_CT_PARTY.PARTY_ID
AND SHIP_CT_REL.PARTY_ID = SHIP_CT_REL_PARTY.PARTY_ID
AND SHIP_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND SHIP_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND SHIP_CT_ACCT_ROLE.CUST_ACCOUNT_ID = SHIP_CT_ROLE_ACCT.CUST_ACCOUNT_ID
AND SHIP_CT_ROLE_ACCT.PARTY_ID = SHIP_CT_REL.OBJECT_ID;
SELECT
SUBSTRB(DEL_CT_PARTY.PERSON_FIRST_NAME
,1
,40) || ' ' || SUBSTRB(DEL_CT_PARTY.PERSON_LAST_NAME
,1
,50)
INTO L_DEL_CONTACT
FROM
HZ_CUST_ACCOUNT_ROLES DEL_CT_ACCT_ROLE,
HZ_PARTIES DEL_CT_PARTY,
HZ_RELATIONSHIPS DEL_CT_REL,
HZ_ORG_CONTACTS DEL_CT_ORG_CONT,
HZ_PARTIES DEL_CT_REL_PARTY,
HZ_CUST_ACCOUNTS DEL_CT_ROLE_ACCT
WHERE DEL_CT_ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = DELIVER_TO_CONTACT_ID
AND DEL_CT_ACCT_ROLE.PARTY_ID = DEL_CT_REL.PARTY_ID
AND DEL_CT_ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND DEL_CT_REL.RELATIONSHIP_ID = DEL_CT_ORG_CONT.PARTY_RELATIONSHIP_ID
AND DEL_CT_REL.SUBJECT_ID = DEL_CT_PARTY.PARTY_ID
AND DEL_CT_REL.PARTY_ID = DEL_CT_REL_PARTY.PARTY_ID
AND DEL_CT_REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DEL_CT_REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DEL_CT_ACCT_ROLE.CUST_ACCOUNT_ID = DEL_CT_ROLE_ACCT.CUST_ACCOUNT_ID
AND DEL_CT_ROLE_ACCT.PARTY_ID = DEL_CT_REL.OBJECT_ID;
SELECT sob.name ,
sob.currency_code
INTO
l_company_name ,
l_functional_currency
FROM gl_sets_of_books sob,
fnd_currencies cur
WHERE sob.set_of_books_id = p_sob_id
AND sob.currency_code = cur.currency_code
;
SELECT cp.user_concurrent_program_name
INTO l_report_name
FROM FND_CONCURRENT_PROGRAMS_VL cp,
FND_CONCURRENT_REQUESTS cr
WHERE cr.request_id = P_CONC_REQUEST_ID
AND cp.application_id = cr.program_application_id
AND cp.concurrent_program_id = cr.concurrent_program_id
;
MODE="SELECT"
DISPLAY="ALL"
TABLEALIAS="SI"
');
SELECT MEANING
INTO l_meaning
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'ITEM_DISPLAY_CODE'
AND LOOKUP_CODE = substr(upper(p_print_description),1,1)
;