APPS.INVCIINT dependencies on MTL_CUSTOMER_ITEMS

Line 2777: FROM MTL_CUSTOMER_ITEMS MCI

2773: SELECT Customer_Item_Id,
2774: Item_Definition_Level, Inactive_Flag
2775: INTO Temp_Model_Customer_Item_Id,
2776: Temp_Item_Definition_Level, Temp_Inactive_Flag
2777: FROM MTL_CUSTOMER_ITEMS MCI
2778: WHERE MCI.Customer_Item_Id =
2779: P_Model_Customer_Item_Id
2780: AND MCI.Customer_Id =
2781: P_Customer_Id;

Line 2822: FROM MTL_CUSTOMER_ITEMS MCI

2818: SELECT Customer_Item_Id,
2819: Item_Definition_Level, Inactive_Flag
2820: INTO Temp_Model_Customer_Item_Id,
2821: Temp_Item_Definition_Level, Temp_Inactive_Flag
2822: FROM MTL_CUSTOMER_ITEMS MCI
2823: WHERE MCI.Customer_Item_Number =
2824: P_Model_Customer_Item
2825: AND MCI.Customer_Id = P_Customer_Id
2826: AND MCI.Customer_Category_Code =

Line 3628: FROM MTL_CUSTOMER_ITEMS MCI

3624: IF (P_Customer_Item_Id IS NOT NULL) THEN
3625:
3626: SELECT Customer_Item_Id, Inactive_Flag
3627: INTO Temp_Customer_Item_Id, Temp_Inactive_Flag
3628: FROM MTL_CUSTOMER_ITEMS MCI
3629: WHERE MCI.Customer_Item_Id = P_Customer_Item_Id;
3630:
3631:
3632: IF (SQL%FOUND) THEN

Line 3648: FROM MTL_CUSTOMER_ITEMS MCI

3644: V_Address_Id, V_Address1, V_Address2, V_Address3, V_Address4, V_City, V_State, V_County, V_Country, V_Postal_Code);
3645:
3646: SELECT Customer_Item_Id, Inactive_Flag
3647: INTO Temp_Customer_Item_Id, Temp_Inactive_Flag
3648: FROM MTL_CUSTOMER_ITEMS MCI
3649: WHERE MCI.Item_Definition_Level = NVL(P_Item_Definition_Level, V_Item_Definition_Level)
3650: AND MCI.Customer_Id = NVL(P_Customer_Id, V_Customer_Id)
3651: AND NVL(MCI.Customer_Category_Code, ' ') = NVL(NVL(P_Customer_Category_Code, V_Customer_Category_Code), ' ')
3652: AND NVL(MCI.Address_Id, -99) = NVL(NVL(P_Address_Id, V_Address_Id), -99)

Line 5287: FROM MTL_CUSTOMER_ITEMS MCI

5283: IF (P_Origin = 'I') THEN
5284:
5285: SELECT Customer_Id, Customer_Item_Number, Item_Definition_Level, Customer_Category_Code, Address_Id
5286: INTO Temp_Customer_Id, Temp_Customer_Item_Number, Temp_Item_Definition_Level, Temp_Customer_Category_Code, Temp_Address_Id
5287: FROM MTL_CUSTOMER_ITEMS MCI
5288: WHERE MCI.Customer_Id = P_Customer_Id
5289: AND MCI.Customer_Item_Number = P_Customer_Item_Number
5290: AND MCI.Item_Definition_Level = P_Item_Definition_Level
5291: AND NVL(MCI.Customer_Category_Code, ' ') = NVL(P_Customer_Category_Code, ' ')

Line 5478: INTO MTL_CUSTOMER_ITEMS(

5474:
5475: IF (P_Origin = 'I') THEN
5476:
5477: INSERT
5478: INTO MTL_CUSTOMER_ITEMS(
5479: Customer_Item_Id,
5480: Last_Update_Date,
5481: Last_Updated_By,
5482: Creation_Date,

Line 5525: MTL_CUSTOMER_ITEMS_S.Nextval,

5521: Program_Update_Date
5522: )
5523: VALUES
5524: (
5525: MTL_CUSTOMER_ITEMS_S.Nextval,
5526: SYSDATE,
5527: NVL(P_Last_Updated_By, -1),
5528: SYSDATE,
5529: NVL(P_Created_By, -1),