[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT PRICE_ADJUSTMENT_ID,ROUND (
DECODE (P.CREDIT_OR_CHARGE_FLAG,'C',-P.OPERAND,P.OPERAND)
,OE_ORDER_UTIL.G_Precision)
BULK COLLECT INTO l_charge_tbl
FROM OE_PRICE_ADJUSTMENTS P
WHERE P.HEADER_ID = p_header_id
AND P.LINE_ID IS NULL
AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
AND P.APPLIED_FLAG = 'Y';
SELECT PRICE_ADJUSTMENT_ID,ROUND (
DECODE (P.CREDIT_OR_CHARGE_FLAG,'C', -1, 1) *
DECODE (P.ARITHMETIC_OPERATOR, 'LUMPSUM',
DECODE (L.ORDERED_QUANTITY,0,0,P.OPERAND),
(L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
,OE_ORDER_UTIL.G_Precision)
BULK COLLECT INTO l_charge_tbl
FROM OE_PRICE_ADJUSTMENTS P,
OE_ORDER_LINES_ALL L
WHERE P.HEADER_ID = p_header_id
AND P.LINE_ID = p_line_id
AND P.LINE_ID = L.LINE_ID
AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
AND P.APPLIED_FLAG = 'Y';
SELECT
/* MOAC_SQL_CHANGE */
s_ship.site_use_id,
s_ship.cust_acct_site_id,
acct_site_ship.cust_account_id,
loc_ship.postal_code,
party.party_name,
cust_acct.account_number,
party.party_id,
party_site_ship.party_site_id,
loc_ship.location_id
FROM HZ_CUST_SITE_USES S_SHIP ,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
HZ_PARTY_SITES PARTY_SITE_SHIP,
HZ_LOCATIONS LOC_SHIP,
HZ_PARTIES PARTY,
HZ_CUST_ACCOUNTS_ALL CUST_ACCT
WHERE s_ship.site_use_id = p_site_org_id
AND s_ship.cust_acct_site_id = acct_site_ship.cust_acct_site_id
AND acct_site_ship.cust_account_id = cust_acct.cust_account_id
AND cust_acct.party_id = party.party_id
AND acct_site_ship.party_site_id = party_site_ship.party_site_id
AND party_site_ship.location_id = loc_ship.location_id;
SELECT location_id
FROM hr_organization_units
WHERE organization_id = p_organization_id;
SELECT *
FROM ZX_DETAIL_TAX_LINES_GT
WHERE application_id = 660
AND entity_code = 'OE_ORDER_HEADERS'
AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
AND trx_id = p_header_id
AND trx_line_id = p_adj_id
AND trx_level_type = 'FREIGHT_CHARGE';
SELECT *
FROM ZX_DETAIL_TAX_LINES_GT
WHERE application_id = 660
AND entity_code = 'OE_ORDER_HEADERS'
AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
AND trx_id = p_header_id
AND trx_line_id = p_line_id
AND trx_level_type = 'LINE'; --'LINE';
SELECT FND_PROFILE.VALUE('ONT_SOURCE_CODE') INTO l_dummy FROM DUAL;
SELECT c.minimum_accountable_unit,
c.precision
INTO l_minimum_accountable_unit,
l_precision
FROM fnd_currencies c
WHERE c.currency_code = l_currency_code;
SELECT
/* MOAC_SQL_CHANGE */
NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
INTO l_cust_trx_type_id
FROM ra_cust_trx_types_all cust_type,
ra_customer_trx cust_trx
WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
AND cust_type.org_id = cust_trx.org_id
AND cust_trx.customer_trx_id = l_commitment_id;
SELECT NVL (ot.cust_trx_type_id, 0)
INTO l_cust_trx_type_id
FROM oe_order_types_v ot,
oe_order_headers_all oh
WHERE ot.order_type_id = oh.order_type_id
AND oh.header_id = l_header_rec.header_id;
SELECT location_id
INTO l_ship_from_location_id
FROM hr_all_organization_units hu
WHERE hu.organization_id = l_ship_from_org_id;
SELECT ASGN.ORGANIZATION_ID ,
hou.location_id
INTO l_poo_party_id ,
l_poo_location_id
FROM RA_SALESREPS_ALL sales ,
PER_ALL_ASSIGNMENTS_F ASGN ,
hr_organization_units hou
WHERE ASGN.PERSON_ID = sales.PERSON_ID
AND sales.salesrep_id = l_salesrep_id
AND sales.org_id = l_header_org_id
AND NVL(ASGN.PRIMARY_FLAG, 'Y') = 'Y'
AND hou.organization_id = ASGN.ORGANIZATION_ID
AND l_TAX_DATE BETWEEN NVL(ASGN.EFFECTIVE_START_DATE,TO_DATE( '01011900' , 'DDMMYYYY')) AND NVL(ASGN.EFFECTIVE_END_DATE,TO_DATE( '31122199', 'DDMMYYYY'))
AND ASSIGNMENT_TYPE = 'E';
SELECT location_id
INTO l_bill_from_location_id
FROM HR_ALL_ORGANIZATION_UNITS
WHERE organization_id = l_header_rec.org_id ;
zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(k) := NULL; -- VARCHAR2_1_tbl_type,
zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(k) := NULL; -- VARCHAR2_1_tbl_type,
zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(k) := NULL; -- VARCHAR2_1_tbl_type,
SELECT line_id
FROM oe_order_lines_all
WHERE header_id = p_header_id
AND open_flag = 'Y'; -- OPEN_FLAG added for bug 9897108
SELECT batch_source_id
INTO l_invoice_source_id
FROM ra_batch_sources
WHERE name = l_invoice_source;
SELECT org_id
,SOLD_TO_ORG_ID
,INVOICE_TO_ORG_ID
,ORDER_TYPE_ID
INTO l_org_id
,l_sold_to_customer_id
,l_invoice_to_org_id
,l_order_type_id
FROM oe_order_headers_all
WHERE header_id = p_header_id;
SELECT acct_site.cust_account_id
INTO l_bill_to_customer_id
FROM HZ_CUST_SITE_USES_ALL site_use ,
HZ_CUST_ACCT_SITES_ALL acct_site
WHERE site_use.site_use_id = l_invoice_to_org_id
AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id;