I am migrating PA expenditures from one Oracle instance to another (both R12.1.3). Is there any extract code available on PA tables (with joins) that provides data that can then by aggregated/translated and placed into PA_TRANSACTION_INTERFACE_ALL. Looking specifically at Capital projects where expenditure has not previously been capitalised.
you need to look into PA_EXPENDITURE_ITEMS_ALL for EIs with COST_DISTRIUTED_FLAG=Y and REVENUE_DISTRIBUTED_FLAG=N. Your Ei should also be marked as billable.
You can try using Capital Data Collection Test, there are queries that show capitalizable cost, you can modify them for your perusal.