DBA Data[Home] [Help]

APPS.MTL_CUSTOMER_ITEMS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	SELECT COUNT(1)
	INTO   Dummy
	FROM   MTL_CUSTOMER_ITEMS
	WHERE  Customer_Id = X_Customer_Id
	AND    NVL(Customer_Category_Code,'JUNK') = NVL(X_Customer_Category_Code,'JUNK')
	AND    NVL(Address_Id,-1000) = NVL(X_Address_Id,-1000)
        AND    Customer_Item_Number = X_Customer_Item_Number
        AND    Item_Definition_Level = X_Item_Definition_Level
	AND    ((X_Rowid IS NULL) OR (ROWID <> X_Rowid));