DBA Data[Home] [Help]

APPS.FTE_FPA_UTIL dependencies on MTL_CATEGORIES_KFV

Line 603: MTL_CATEGORIES_KFV C,

599: NVL( SUM(FL.APPROVED_AMOUNT),0 ),
600: MAX(FH.CURRENCY_CODE)
601: FROM FTE_INVOICE_HEADERS FH,
602: FTE_INVOICE_LINES FL,
603: MTL_CATEGORIES_KFV C,
604: MTL_CATEGORY_SETS S
605: WHERE FH.INVOICE_HEADER_ID = FL.INVOICE_HEADER_ID
606: AND FH.BOL = p_bol
607: AND FL.FREIGHT_CLASS = C.CONCATENATED_SEGMENTS

Line 1267: MTL_CATEGORIES_KFV C,

1263: WSH_DELIVERY_LEGS WDL,
1264: WSH_TRIP_STOPS WTS,
1265: WSH_TRIPS WT,
1266: MTL_ITEM_CATEGORIES MIC,
1267: MTL_CATEGORIES_KFV C,
1268: MTL_CATEGORY_SETS S
1269: WHERE
1270: S.STRUCTURE_ID = C.STRUCTURE_ID
1271: AND S.CATEGORY_SET_NAME ='WSH_COMMODITY_CODE'

Line 1629: MTL_CATEGORIES_KFV C,

1625: WSH_DELIVERY_LEGS WDL,
1626: WSH_TRIP_STOPS WTS,
1627: WSH_TRIPS WT,
1628: MTL_ITEM_CATEGORIES MIC,
1629: MTL_CATEGORIES_KFV C,
1630: MTL_CATEGORY_SETS S
1631: WHERE
1632: S.STRUCTURE_ID = C.STRUCTURE_ID
1633: AND S.CATEGORY_SET_NAME ='WSH_COMMODITY_CODE'