DBA Data[Home] [Help]

APPS.INVCIINT dependencies on MTL_COMMODITY_CODES

Line 2665: FROM MTL_COMMODITY_CODES MCC

2661: IF (P_Commodity_Code_Id IS NOT NULL) THEN
2662:
2663: SELECT Commodity_Code_Id, Inactive_Date
2664: INTO Temp_Commodity_Code_Id, Temp_Inactive_Date
2665: FROM MTL_COMMODITY_CODES MCC
2666: WHERE MCC.Commodity_Code_Id = P_Commodity_Code_Id;
2667:
2668: IF ((SQL%FOUND) AND ((Temp_Inactive_Date IS NOT NULL)
2669: AND (Temp_Inactive_Date <= SYSDATE))) THEN

Line 2691: FROM MTL_COMMODITY_CODES MCC

2687: (P_Commodity_Code IS NOT NULL)) THEN
2688:
2689: SELECT Commodity_Code_Id, Inactive_Date
2690: INTO Temp_Commodity_Code_Id, Temp_Inactive_Date
2691: FROM MTL_COMMODITY_CODES MCC
2692: WHERE MCC.Commodity_Code = P_Commodity_Code;
2693:
2694: IF ((SQL%FOUND) AND
2695: ((Temp_Inactive_Date IS NOT NULL) AND