[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
SELECT
MEANING
INTO LP_ACTIVE_ONLY
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = UPPER(SUBSTR(P_ACTIVE_MODIFIER_ONLY
,1
,1));
SELECT
MEANING
INTO LP_ACTIVE_LINES_ONLY
FROM
FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = UPPER(SUBSTR(P_ACTIVE_MODIFIER_LINES
,1
,1));
SELECT
MEANING
FROM
QP_LOOKUPS
WHERE LOOKUP_TYPE = 'LIST_TYPE_CODE'
AND LOOKUP_CODE = LIST_TYPE_CODE;
SELECT
NAME
FROM
QP_LIST_HEADERS_VL
WHERE LIST_HEADER_ID = PARENT_LIST_HEADER_ID;
SELECT
VERSION_NO
FROM
QP_LIST_HEADERS_VL
WHERE LIST_HEADER_ID = PARENT_LIST_HEADER_ID;
SELECT
QLL.LIST_LINE_NO
FROM
QP_LIST_LINES QLL
WHERE QLL.LIST_LINE_ID = (
SELECT
QR.TO_RLTD_MODIFIER_ID
FROM
QP_RLTD_MODIFIERS QR,
QP_LIST_LINES QL
WHERE QR.FROM_RLTD_MODIFIER_ID = QL.LIST_LINE_ID
AND QR.FROM_RLTD_MODIFIER_ID = LIST_LINE_ID1
AND QR.RLTD_MODIFIER_GRP_TYPE = 'COUPON' );
SELECT
APPLICATION_ID
FROM
FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = APP_SHORT_NAME;
SELECT
ORDER_NUMBER
INTO L_QUALIFIER_ATTR_VALUE
FROM
OE_BLANKET_HEADERS_ALL
WHERE HEADER_ID = QUALIFIER_ATTR_VALUE;
SELECT
H.ORDER_NUMBER || '-' || L.LINE_NUMBER
INTO L_QUALIFIER_ATTR_VALUE
FROM
OE_BLANKET_HEADERS_ALL H,
OE_BLANKET_LINES_ALL L
WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE
AND H.HEADER_ID = L.HEADER_ID;
SELECT
ORDER_NUMBER
INTO L_QUALIFIER_ATTR_VALUE_TO
FROM
OE_BLANKET_HEADERS_ALL
WHERE HEADER_ID = QUALIFIER_ATTR_VALUE_TO;
SELECT
H.ORDER_NUMBER || '-' || L.LINE_NUMBER
INTO L_QUALIFIER_ATTR_VALUE_TO
FROM
OE_BLANKET_HEADERS_ALL H,
OE_BLANKET_LINES_ALL L
WHERE L.LINE_ID = QUALIFIER_ATTR_VALUE_TO
AND H.HEADER_ID = L.HEADER_ID;
LP_CUSTOMER_ID := ' And Exists (SELECT NULL
FROM qp_qualifiers q
WHERE qualifier_context = ''CUSTOMER''
AND a.list_header_id = q.list_header_id
AND qualifier_attribute = ''QUALIFIER_ATTRIBUTE2''
AND qualifier_attr_value = :P_customer_id) ';
LP_CUSTOMER_CLASS_ID := ' And Exists (SELECT NULL
FROM qp_qualifiers q
WHERE qualifier_context = ''CUSTOMER''
AND a.list_header_id = q.list_header_id
AND qualifier_attribute = ''QUALIFIER_ATTRIBUTE1''
AND qualifier_attr_value = :P_customer_class_id) ';
LP_PRICE_LIST_ID := ' And Exists (SELECT NULL
FROM qp_qualifiers q
WHERE qualifier_context = ''MODLIST''
AND a.list_header_id = q.list_header_id
AND qualifier_attribute = ''QUALIFIER_ATTRIBUTE4''
AND qualifier_attr_value = :P_price_list_id) ';
LP_ITEM_ID := ' And Exists (SELECT NULL
FROM qp_pricing_attributes q
WHERE product_attribute_context = ''ITEM''
AND a.list_header_id = q.list_header_id
AND product_attribute = ''PRICING_ATTRIBUTE1''
AND product_attr_value = :P_item_id) ';
LP_ITEM_CATEGORY_ID := ' And Exists (SELECT NULL
FROM qp_pricing_attributes q
WHERE product_attribute_context = ''ITEM''
AND a.list_header_id = q.list_header_id
AND product_attribute = ''PRICING_ATTRIBUTE2''
AND product_attr_value = :P_item_category_id) ';
SELECT
MEANING
FROM
QP_LOOKUPS
WHERE LOOKUP_TYPE = 'QP_NET_AMOUNT_CALCULATION'
AND LOOKUP_CODE = NET_AMOUNT_FLAG;
SELECT
OPERAND
FROM
QP_LIST_LINES
WHERE LIST_LINE_ID = BENEFIT_PRICE_LIST_LINE_ID;