[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT line_id,ordered_quantity,order_quantity_uom,inventory_item_id
FROM oe_order_lines_all
WHERE line_id = il6;
CURSOR sel_ato_lines(ln_id number) is select line_id,ato_line_id,ordered_quantity,inventory_itEM_ID,ORDER_QUANTITY_UOM
FROM oe_order_lines_all
WHERE ato_line_id = ln_id;
CURSOR n_lst_price(id number,unt varchar2) is /*select list_price
FROM so_price_list_lines_115
WHERE inventory_item_id = id
AND unit_code = unt
AND price_list_id = new_list; */ /*Changed cursor query for bug 16574430 */
SELECT qpll.operand list_price
FROM qp_list_lines qpll,
qp_pricing_attributes qppr
WHERE qppr.list_line_id = qpll.list_line_id
AND qpll.list_header_id = new_list
AND qppr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND qppr.product_attribute = 'PRICING_ATTRIBUTE1'
AND qppr.product_attr_value = to_char(id)
and qppr.PRICING_ATTRIBUTE_CONTEXT is null
and qppr.PRICING_ATTRIBUTE is null
and qppr.EXCLUDER_FLAG = 'N'
AND qppr.product_uom_code = unt
and qpll.LIST_LINE_TYPE_CODE='PLL'
and qpll.pricing_phase_id=1
and mod(qpll.QUALIFICATION_IND,2)=0;
SELECT NVL(cust_acct_site_id , 0) address_id
FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
SELECT
b.operand list_price,
c.product_uom_code list_price_uom_code ,
qlhb.currency_code /* Added for bug#8844209 */
FROM
JAI_CMN_CUS_ADDRESSES a,
qp_list_lines b,
qp_pricing_attributes c ,
qp_list_headers_b qlhb /* Added for bug#8844209 */
WHERE
a.customer_id = p_customer_id AND
a.address_id = p_address_id AND
a.price_list_id = b.LIST_header_ID AND
c.list_line_id = b.list_line_id AND
c.product_attr_value = to_char(p_inventory_item_id) AND
c.product_uom_code = p_uom_code AND
qlhb.list_header_id = b.list_header_id AND /* Added for bug#8844209 */
p_ordered_date BETWEEN nvl( qlhb.start_date_active, p_ordered_date) AND
nvl( qlhb.end_date_active, SYSDATE) AND
p_ordered_date BETWEEN nvl( b.start_date_active, p_ordered_date) AND
nvl( b.end_date_active, SYSDATE);
SELECT
b.operand list_price,
c.product_uom_code list_price_uom_code ,
qlhb.currency_code /* Added for bug#8844209 */
FROM
JAI_CMN_CUS_ADDRESSES a,
qp_list_lines b,
qp_pricing_attributes c,
qp_list_headers_b qlhb /* Added for bug#8844209 */
WHERE
a.customer_id = p_customer_id AND
a.address_id = p_address_id AND
a.price_list_id = b.list_header_id AND
c.list_line_id = b.list_line_id AND
c.product_attr_value = to_char(p_inventory_item_id) AND
trunc(nvl(b.end_date_active,sysdate)) >= trunc(p_ordered_date) AND
qlhb.list_header_id = b.list_header_id AND /* Added for bug#8844209 */
nvl(qlhb.active_flag,'N') = 'Y' AND /*added for bug#8844209*/
primary_uom_flag ='Y'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
SELECT
b.operand list_price,
c.product_uom_code list_price_uom_code ,
qlhb.currency_code /* Added for bug#8844209 */
FROM
JAI_CMN_CUS_ADDRESSES a,
qp_list_lines b,
qp_pricing_attributes c,
qp_list_headers_b qlhb /* Added for bug#8844209 */
WHERE
a.customer_id = p_customer_id AND
a.address_id = p_address_id AND
a.price_list_id = b.LIST_header_ID AND
c.list_line_id = b.list_line_id AND
c.PRODUCT_ATTR_VALUE = TO_CHAR(p_inventory_item_id) AND
qlhb.list_header_id = b.list_header_id AND /* Added for bug#8844209 */
NVL(qlhb.end_date_active,SYSDATE) >= p_ordered_date AND
NVL(qlhb.active_flag,'N') = 'Y' AND /*Added for bug#8844209*/
(b.end_date_active is null OR b.end_date_active >= p_ordered_date); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
SELECT
category_set_name
FROM
mtl_default_category_sets_fk_v
WHERE functional_area_desc = 'Order Entry';
SELECT
b.operand list_price
, c.product_uom_code list_price_uom_code,
qlhb.currency_code /* Added for bug#8844209 */
FROM
jai_cmn_cus_addresses a
, qp_list_lines b
, qp_pricing_attributes c ,
qp_list_headers_b qlhb /* Added for bug#8844209 */
WHERE a.customer_id = pn_party_id
AND a.address_id = pn_address_id
AND a.price_list_id = b.list_header_id
AND c.list_line_id = b.list_line_id
AND c.product_uom_code = pv_uom_code
AND qlhb.list_header_id = b.list_header_id /* Added for bug#8844209 */
AND NVL(qlhb.end_date_active,SYSDATE) >= pd_ordered_date
AND NVL(qlhb.active_flag,'N') = 'Y' /*Added for bug#8844209*/
AND pd_ordered_date BETWEEN NVL( b.start_date_active, pd_ordered_date)
AND NVL( b.end_date_active, SYSDATE)
AND EXISTS ( SELECT
'x'
FROM
mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id)
);
SELECT
b.operand list_price
, c.product_uom_code list_price_uom_code,
qlhb.currency_code /* Added for bug#8844209 */
FROM
jai_cmn_cus_addresses a
, qp_list_lines b
, qp_pricing_attributes c ,
qp_list_headers_b qlhb /* Added for bug#8844209 */
WHERE a.customer_id = pn_party_id
AND a.address_id = pn_address_id
AND a.price_list_id = b.list_header_id
AND c.list_line_id = b.list_line_id
AND qlhb.list_header_id = b.list_header_id /* Added for bug#8844209 */
AND NVL(qlhb.end_date_active,SYSDATE) >= pd_ordered_date
AND NVL(qlhb.active_flag,'N') = 'Y'
AND TRUNC(NVL(b.end_date_active,SYSDATE)) >= TRUNC(pd_ordered_date)
AND NVL(primary_uom_flag,'N') ='Y'
AND EXISTS ( SELECT
'x'
FROM
mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id)
);
SELECT
b.operand list_price
, c.product_uom_code list_price_uom_code,
qlhb.currency_code /* Added for bug#8844209 */
FROM
jai_cmn_cus_addresses a
, qp_list_lines b
, qp_pricing_attributes c ,
qp_list_headers_b qlhb /* Added for bug#8844209 */
WHERE a.customer_id = pn_party_id
AND a.address_id = pn_address_id
AND a.price_list_id = b.list_header_id
AND c.list_line_id = b.list_line_id
AND qlhb.list_header_id = b.list_header_id /* Added for bug#8844209 */
AND NVL(qlhb.end_date_active,SYSDATE) >= pd_ordered_date
AND NVL(qlhb.active_flag,'N') = 'Y'
AND TRUNC(NVL(b.end_date_active,SYSDATE)) >= TRUNC(pd_ordered_date)
AND EXISTS ( SELECT
'x'
FROM
mtl_item_categories_v d
WHERE d.category_set_name = lv_category_set_name
AND d.inventory_item_id = pn_inventory_item_id
AND c.product_attr_value = TO_CHAR(d.category_id)
);
SELECT LINE_ID,ORDERED_QUANTITY,ORDER_QUANTITY_UOM,INVENTORY_ITEM_ID
FROM OE_ORDER_LINES_ALL
WHERE LINE_ID = IL6;
SELECT LINE_ID,ATO_LINE_ID,ORDERED_QUANTITY,INVENTORY_ITEM_ID,ORDER_QUANTITY_UOM
FROM OE_ORDER_LINES_ALL
WHERE ATO_LINE_ID = LN_ID;
/*SELECT LIST_PRICE
FROM SO_PRICE_LIST_LINES_115
WHERE INVENTORY_ITEM_ID = INVENT
AND UNIT_CODE = UNT
AND PRICE_LIST_ID = NEW_NO
AND SYSDATE BETWEEN
NVL(START_DATE_ACTIVE,SYSDATE)
AND NVL(END_DATE_ACTIVE,SYSDATE);*/ /*Changed cursor query for bug 16574430 */
SELECT qpll.operand list_price
FROM qp_list_lines qpll,
qp_pricing_attributes qppr
WHERE qppr.list_line_id = qpll.list_line_id
AND qpll.list_header_id = new_no
AND qppr.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND qppr.product_attribute = 'PRICING_ATTRIBUTE1'
AND qppr.product_attr_value = to_char(invent)
and qppr.PRICING_ATTRIBUTE_CONTEXT is null
and qppr.PRICING_ATTRIBUTE is null
and qppr.EXCLUDER_FLAG = 'N'
AND qppr.product_uom_code = unt
AND nvl(qpll.start_date_active, sysdate -1) <= sysdate
AND nvl(qpll.end_date_active, sysdate + 1) >= sysdate
and qpll.LIST_LINE_TYPE_CODE='PLL'
and qpll.pricing_phase_id=1
and mod(qpll.QUALIFICATION_IND,2)=0;
SELECT
'1'
FROM
JAI_OM_OE_SO_TAXES tl,
JAI_CMN_TAXES_ALL tc
WHERE
tc.tax_type = jai_constants.tax_type_modvat_recovery AND /*--'Modvat Recovery' Ramananda for removal of SQL LITERALs :bug#4428980*/
tc.tax_id = tl.tax_id AND
tl.line_id = p_line_id ;