[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
INTO l_curr_valid
FROM fnd_currencies
WHERE currency_code = p_currency_code
AND enabled_flag = 'Y'
AND NVL(start_date_active, TO_DATE('01/01/1000','DD/MM/YYYY'))
<= TRUNC(SYSDATE)
AND NVL(end_date_active, TO_DATE('31/12/9999','DD/MM/YYYY'))
>= TRUNC(SYSDATE) ;
SELECT NVL(multi_org_flag, 'N')
INTO l_multi_org_flag
FROM fnd_product_groups;
SELECT organization_id
INTO l_org_id
FROM hr_operating_units
WHERE organization_id = p_org_id;
SELECT organization_id
INTO l_org_id
FROM hr_operating_units
WHERE name = p_operating_unit_name;
SELECT credit_check_rule_id,
name,
credit_check_level_code,
check_item_categories_flag
INTO l_credit_check_rule_id,
l_credit_check_rule_name,
l_credit_check_level_code,
l_check_item_categories_flag
FROM oe_credit_check_rules
WHERE credit_check_rule_id = p_credit_check_rule_id;
SELECT credit_check_rule_id,
name,
credit_check_level_code,
check_item_categories_flag
INTO l_credit_check_rule_id,
l_credit_check_rule_name,
l_credit_check_level_code,
l_check_item_categories_flag
FROM oe_credit_check_rules
WHERE name = p_credit_check_rule_name;
SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
FROM OE_INVOICE_TO_ORGS_V
WHERE ADDRESS_LINE_1 = p_bill_to_address1
AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
nvl( p_bill_to_address2, fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
nvl( p_bill_to_address3,fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
nvl( p_bill_to_address4,fnd_api.g_miss_char)
AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
nvl( p_bill_to_city, fnd_api.g_miss_char)
AND nvl(STATE,fnd_api.g_miss_char) =
nvl( p_bill_to_state, fnd_api.g_miss_char)
AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
AND nvl(COUNTRY,fnd_api.g_miss_char) =
nvl( p_bill_to_country, fnd_api.g_miss_char)
AND STATUS = 'A'
AND CUSTOMER_ID = p_customer_id
and address_status='A'; --2752321
SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
FROM OE_INVOICE_TO_ORGS_V
WHERE ADDRESS_LINE_1 = p_bill_to_address1
AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
nvl( p_bill_to_address2, fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
nvl( p_bill_to_address3,fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
nvl( p_bill_to_address4,fnd_api.g_miss_char)
AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
nvl( p_bill_to_city, fnd_api.g_miss_char)
AND nvl(STATE,fnd_api.g_miss_char) =
nvl( p_bill_to_state, fnd_api.g_miss_char)
AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
AND nvl(COUNTRY,fnd_api.g_miss_char) =
nvl( p_bill_to_country, fnd_api.g_miss_char)
AND STATUS = 'A'
and address_status='A' --2752321
AND CUSTOMER_ID IN
(
SELECT p_customer_id
FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID
FROM HZ_CUST_ACCT_RELATE
WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id
AND bill_to_flag = 'Y');
SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
FROM OE_INVOICE_TO_ORGS_V
WHERE ADDRESS_LINE_1 = p_bill_to_address1
AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
nvl( p_bill_to_address2, fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
nvl( p_bill_to_address3,fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_4, fnd_api.g_miss_char) =
nvl( p_bill_to_address4,fnd_api.g_miss_char)
AND nvl(TOWN_OR_CITY,fnd_api.g_miss_char) =
nvl( p_bill_to_city, fnd_api.g_miss_char)
AND nvl(STATE,fnd_api.g_miss_char) =
nvl( p_bill_to_state, fnd_api.g_miss_char)
AND nvl(POSTAL_CODE,fnd_api.g_miss_char) =
nvl( p_bill_to_postal_code, fnd_api.g_miss_char)
AND nvl(COUNTRY,fnd_api.g_miss_char) =
nvl( p_bill_to_country, fnd_api.g_miss_char)
AND STATUS = 'A'
and address_status='A'; --2752321
SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
INTO l_bill_to_site_use_id
FROM OE_INVOICE_TO_ORGS_V
WHERE ADDRESS_LINE_1 = p_bill_to_address1
AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
nvl( p_bill_to_address2, fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
nvl( p_bill_to_address3,fnd_api.g_miss_char)
AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
DECODE(STATE, NULL, NULL, STATE || ', ')||
DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
DECODE(COUNTRY, NULL, NULL, COUNTRY) =
NVL( p_bill_to_address4, fnd_api.g_miss_char)
AND STATUS = 'A'
AND CUSTOMER_ID = p_customer_id
and address_status='A'; --2752321;
SELECT /* MOAC_SQL_NO_CHANGE */ ORGANIZATION_ID
INTO l_bill_to_site_use_id
FROM OE_INVOICE_TO_ORGS_V
WHERE ADDRESS_LINE_1 = p_bill_to_address1
AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
nvl( p_bill_to_address2, fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
nvl( p_bill_to_address3,fnd_api.g_miss_char)
AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
DECODE(STATE, NULL, NULL, STATE || ', ')||
DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
DECODE(COUNTRY, NULL, NULL, COUNTRY) =
nvl( p_bill_to_address4, fnd_api.g_miss_char)
AND STATUS = 'A'
and address_status='A' --2752321
AND CUSTOMER_ID IN
(SELECT p_customer_id
FROM DUAL
UNION
SELECT CUST_ACCOUNT_ID
FROM HZ_CUST_ACCT_RELATE
WHERE RELATED_CUST_ACCOUNT_ID = p_customer_id
AND bill_to_flag = 'Y');
oe_debug_pub.add('after select found='||l_bill_to_site_use_id);
SELECT ORGANIZATION_ID
INTO l_bill_to_site_use_id
FROM OE_INVOICE_TO_ORGS_V
WHERE ADDRESS_LINE_1 = p_bill_to_address1
AND nvl( ADDRESS_LINE_2, fnd_api.g_miss_char) =
nvl( p_bill_to_address2, fnd_api.g_miss_char)
AND nvl( ADDRESS_LINE_3, fnd_api.g_miss_char) =
nvl( p_bill_to_address3,fnd_api.g_miss_char)
AND DECODE(TOWN_OR_CITY,NULL,NULL,TOWN_OR_CITY||', ')||
DECODE(STATE, NULL, NULL, STATE || ', ')||
DECODE(POSTAL_CODE, NULL, NULL, POSTAL_CODE || ', ')||
DECODE(COUNTRY, NULL, NULL, COUNTRY) =
NVL( p_bill_to_address4, fnd_api.g_miss_char)
AND STATUS = 'A'
and address_status='A'; --2752321
SELECT site_use_id
INTO l_bill_to_site_use_id
FROM hz_cust_site_uses_all
WHERE site_use_id = p_bill_to_site_use_id
AND site_use_code = 'BILL_TO'
AND NVL(org_id, -99) = NVL(p_org_id, -99);
SELECT hca.cust_account_id
INTO l_customer_id
FROM hz_cust_accounts hca,
hz_parties hp
WHERE hca.party_id = hp.party_id
AND hp.party_name = p_customer_name
AND hca.account_number = p_customer_number;
FND_MSG_PUB.Delete_Msg;