[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT Customer_Item_Id, Address_Id, Customer_Category_Code,
Inactive_Flag, Item_Definition_Level
FROM MTL_CUSTOMER_ITEMS
WHERE Customer_Id = v_Customer_Id
AND Item_Definition_Level in
(Temp_level_1, Temp_level_2, Temp_level_3)
AND ( (Y_Customer_Item_Id is NULL AND
Customer_Item_Number = Y_Customer_Item_Number)
OR Customer_Item_Id = Y_Customer_Item_Id)
ORDER BY Item_Definition_Level DESC;
SELECT Master_Organization_Id, Inventory_Item_Id, Inactive_Flag
FROM MTL_CUSTOMER_ITEM_XREFS
WHERE Customer_Item_Id = TmpCustItemId
AND Inventory_Item_Id =
NVL(Y_Inventory_Item_Id, Inventory_Item_Id)
AND Master_Organization_Id =
(SELECT Master_Organization_Id
FROM MTL_PARAMETERS
WHERE Organization_Id = Y_Organization_Id)
ORDER BY Preference_Number ASC;
SELECT MCIXRF.Customer_Item_Id,
MCI.Customer_Item_Number,
MCI.Customer_Category_Code,
MCI.Customer_Id,
MCI.Address_Id,
MCI.Item_Definition_Level,
MCI.Customer_Item_Desc,
MCI.Model_Customer_Item_Id,
MCI.Commodity_Code_Id,
MCI.Master_Container_Item_Id,
MCI.Container_Item_Org_Id,
MCI.Detail_Container_Item_Id,
MCI.Min_Fill_Percentage,
MCI.Dep_Plan_Required_Flag,
MCI.Dep_Plan_Prior_Bld_Flag,
MCI.Demand_Tolerance_Positive,
MCI.Demand_Tolerance_Negative,
MCIXRF.Inventory_Item_Id,
MCIXRF.Master_Organization_Id,
MCIXRF.Preference_Number,
MCI.Attribute_Category,
MCI.Attribute1,
MCI.Attribute2,
MCI.Attribute3,
MCI.Attribute4,
MCI.Attribute5,
MCI.Attribute6,
MCI.Attribute7,
MCI.Attribute8,
MCI.Attribute9,
MCI.Attribute10,
MCI.Attribute11,
MCI.Attribute12,
MCI.Attribute13,
MCI.Attribute14,
MCI.Attribute15
FROM MTL_SYSTEM_ITEMS MSI,
MTL_CUSTOMER_ITEM_XREFS MCIXRF,
MTL_CUSTOMER_ITEMS MCI
WHERE MCIXRF.Customer_Item_Id = TmpCustItemId
AND MCIXRF.Inventory_Item_Id = TmpInvItemId
AND MCIXRF.Master_Organization_Id = TmpMstrOrgId
AND MCI.Customer_Item_Id = MCIXRF.Customer_item_Id
AND MSI.Inventory_Item_Id = MCIXRF.Inventory_Item_Id
AND MSI.Organization_id = MCIXRF.Master_Organization_Id;
SELECT CUSTOMER_ID
FROM RA_ADDRESSES
WHERE ADDRESS_ID = v_Address_Id; */
/* SELECT ACCT_SITE.CUST_ACCOUNT_ID
FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = v_Address_Id
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
AND NVL(ACCT_SITE.ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99)) =
NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);*/
SELECT ACCT_SITE.CUST_ACCOUNT_ID
FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = v_Address_Id;
SELECT Customer_Category_Code
INTO RA_Address_Category
FROM RA_ADDRESSES
WHERE Address_Id = Y_Address_Id;
SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
INTO RA_Address_Category
FROM HZ_PARTY_SITES PARTY_SITE, HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99)
AND NVL(ACCT_SITE.ORG_ID,
NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99)) =
NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,
SUBSTRB(USERENV('CLIENT_INFO'),1,10))),- 99);
SELECT ACCT_SITE.CUSTOMER_CATEGORY_CODE
INTO RA_Address_Category
FROM HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE ACCT_SITE.CUST_ACCT_SITE_ID = Y_Address_Id;