APPS.IPA_APIS dependencies on PA_PROJECT_ASSETS_ALL

Line 45: FROM pa_project_assets_all

41: project_asset_id , asset_name , asset_number,
42: book_type_code , asset_units ,
43: asset_category_id , location_id ,
44: depreciate_flag , depreciation_expense_ccid
45: FROM pa_project_assets_all
46: WHERE (nvl(attribute8,'!@#') = nvl(grouping_method1,nvl(attribute8,'!@#'))
47: AND nvl(attribute9,'!@#') = nvl(grouping_method2,nvl(attribute9,'!@#'))
48: AND nvl(attribute10,'!@#') = nvl(grouping_method3,nvl(attribute10,'!@#')))
49: AND project_id = l_project_id

Line 66: FROM pa_project_assets_all

62: project_asset_id , asset_name , asset_number,
63: book_type_code , asset_units ,
64: asset_category_id , location_id ,
65: depreciate_flag , depreciation_expense_ccid
66: FROM pa_project_assets_all
67: WHERE (nvl(attribute8,'!@#') = grouping_method1
68: AND nvl(attribute9,'!@#') = nvl(grouping_method2,nvl(attribute9,'!@#'))
69: AND nvl(attribute10,'!@#') = nvl(grouping_method3,nvl(attribute10,'!@#')))
70: AND capitalized_flag <> 'Y' ;

Line 80: FROM pa_project_assets_all

76: project_asset_id , asset_name , asset_number,
77: book_type_code , asset_units ,
78: asset_category_id , location_id ,
79: depreciate_flag , depreciation_expense_ccid
80: FROM pa_project_assets_all
81: WHERE (nvl(attribute8,'!@#') = nvl(grouping_method1,nvl(attribute8,'!@#'))
82: AND nvl(attribute9,'!@#') = grouping_method2
83: AND nvl(attribute10,'!@#') = nvl(grouping_method3,nvl(attribute10,'!@#')))
84: AND capitalized_flag <> 'Y' ;

Line 94: FROM pa_project_assets_all

90: project_asset_id , asset_name , asset_number,
91: book_type_code , asset_units ,
92: asset_category_id , location_id ,
93: depreciate_flag , depreciation_expense_ccid
94: FROM pa_project_assets_all
95: WHERE (nvl(attribute8,'!@#') = nvl(grouping_method1,nvl(attribute8,'!@#'))
96: AND nvl(attribute9,'!@#') = nvl(grouping_method2,nvl(attribute9,'!@#'))
97: AND nvl(attribute10,'!@#') = grouping_method3)
98: AND capitalized_flag <> 'Y' ;

Line 105: FROM pa_project_assets_all

101: SELECT project_asset_id , asset_name , asset_number ,
102: book_type_code , asset_units ,
103: asset_category_id , location_id ,
104: depreciate_flag , depreciation_expense_ccid
105: FROM pa_project_assets_all
106: WHERE project_id = i_project_id
107: AND capitalized_flag <> 'Y' ;
108: apis_rec apis_intf%ROWTYPE ;
109: asset_rec asset_cur%ROWTYPE ;

Line 240: FROM pa_project_assets_all pa,

236: l_project_asset_id ,l_asset_name , l_asset_number ,
237: l_book_type_code ,l_asset_units ,
238: l_asset_category_id ,l_asset_location_id ,
239: l_depreciate_flag ,l_depreciation_expense_ccid
240: FROM pa_project_assets_all pa,
241: pa_projects_all pp,
242: pa_project_types ppt
243: WHERE ( pa.project_asset_id = apis_rec.project_asset_id
244: OR pa.asset_number = apis_rec.asset_number

Line 360: FROM pa_project_assets_all

356: avoiding the query.
357:
358: SELECT count(*)
359: INTO l_count
360: FROM pa_project_assets_all
361: WHERE (
362: nvl(attribute8,'!@#') = nvl(apis_rec.grouping_method1,nvl(attribute8,'!@#'))
363: AND nvl(attribute9,'!@#') = nvl(apis_rec.grouping_method2,nvl(attribute9,'!@#'))
364: AND nvl(attribute10,'!@#') = nvl(apis_rec.grouping_method3,nvl(attribute10,'!@#'))

Line 498: FROM pa_project_assets_all

494:
495: CURSOR asset_cur ( i_project_id NUMBER )
496: IS
497: SELECT project_asset_id , date_placed_in_service
498: FROM pa_project_assets_all
499: WHERE project_id = i_project_id
500: and date_placed_in_service is not null;
501:
502: asset_rec asset_cur%ROWTYPE ;

Line 640: UPDATE pa_project_assets_all

636: warning_msg) ;
637:
638: elsif result = 1 then
639:
640: UPDATE pa_project_assets_all
641: SET date_placed_in_service = i_date_placed_in_service,
642: attribute6 = i_asset_status
643: --Bug 3068204
644: ,project_asset_type = 'AS-BUILT'