DBA Data[Home] [Help]

APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2011: financials_system_params_all fsp, gl_sets_of_books gsob

2007: NVL(fav.item_type, 'NONCATALOG') source_type,
2008: DECODE(NVL(line_types.order_type_lookup_code, 'QUANTITY'),
2009: 'QUANTITY', NULL, fav.unit_price) amount
2010: FROM por_favorite_list_lines fav, po_line_types_b line_types,
2011: financials_system_params_all fsp, gl_sets_of_books gsob
2012: WHERE favorite_list_line_id = gIFLOOldFavoriteListLineIdTbl(i)
2013: AND favorite_list_id = gIFLOFavoriteListIdTbl(i)
2014: AND fav.line_type_id = line_types.line_type_id (+)
2015: AND fsp.org_id = gIFLOOrgIdTbl(i)