DBA Data[Home] [Help]

APPS.GMO_OC_TRANS_PKG dependencies on DUAL

Line 39: (select meaning from fnd_lookups where lookup_type = 'GMO_OC_TRANS_LOV' and lookup_code = OBJECT_ID),null) from dual;

35: CURSOR GET_OBJECT IS
36: select DECODE(object_type,1,
37: (select concatenated_segments from mtl_system_items_kfv where inventory_item_id = OBJECT_ID and organization_id = Plant),2,
38: (select resources from cr_rsrc_dtl where resource_id = OBJECT_ID),3,
39: (select meaning from fnd_lookups where lookup_type = 'GMO_OC_TRANS_LOV' and lookup_code = OBJECT_ID),null) from dual;
40: BEGIN
41: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CP : GENERATE_XML(OC) : START ');
42: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Input Parameter - Plant :'||Plant||' and Object Type:'||Object_type||' and Object_id :'||Object_id||' From Date :'||FromDate||' To Date :'||ToDate||' Operator_id:'||Operator_id);
43: l_from_date := null;