APPS.INVCIINT dependencies on MTL_CUSTOMER_ITEMS

Line 2776: FROM MTL_CUSTOMER_ITEMS MCI

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

Line 2821: FROM MTL_CUSTOMER_ITEMS MCI

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

Line 3627: FROM MTL_CUSTOMER_ITEMS MCI

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

Line 3647: FROM MTL_CUSTOMER_ITEMS MCI

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

Line 5286: FROM MTL_CUSTOMER_ITEMS MCI

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

Line 5477: INTO MTL_CUSTOMER_ITEMS(

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

Line 5524: MTL_CUSTOMER_ITEMS_S.Nextval,

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