DBA Data[Home] [Help]

APPS.INVCIINT dependencies on MTL_COMMODITY_CODES

Line 2666: FROM MTL_COMMODITY_CODES MCC

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

Line 2692: FROM MTL_COMMODITY_CODES MCC

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