CSE_ASSETS_FLAT

Details

Schema: FUSION
Object owner: CSE
Object type: VIEW

Columns

Name
ASSET_ID ASSET_NUMBER ITEM_ID ITEM_NUMBER OPER_ORGANIZATION_ID OPER_ORGANIZATION_CODE SERIAL_NUMBER LOT_NUMBER QUANTITIY CURRENT_LOCATION_CONTEXT CURRENT_LOCATION_ID LOCATION_ORGANIZATION_ID LOCATION_ORGANIZATION_CODE SUBINVENTORY_CODE INVENTORY_LOCATOR_ID WORK_CENTER_ID WORK_CENTER_CODE WORK_ORDER_ID WORK_ORDER_OPERATION_ID SALES_ORDER_ID SALES_ORDER_NUMBER SALES_ORDER_LINE_ID SALES_ORDER_LINE_NUMBER CUSTOMER_ID CUSTOMER_NAME CUSTOMER_NUMBER SITE_CUSTOMER_ID SITE_CUSTOMER_NAME SITE_CUSTOMER_NUMBER CUSTOMER_SITE_ID CUSTOMER_SITE_NAME CUSTOMER_SITE_NUMBER BILL_TO_CUSTOMER_ID BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_SITE_ID BILL_TO_CUSTOMER_SITE_NAME BILL_TO_CUSTOMER_SITE_NUMBER CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_NAME CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_SITE_ID CUSTOMER_ACCOUNT_SITE_NAME CUSTOMER_ACCOUNT_SITE_NUMBER INTERNAL_LOCATION_CODE SOLD_BY_BUSINESS_UNIT_ID BUSINESS_UNIT_NAME

Name

ASSET_ID

ASSET_NUMBER

ITEM_ID

ITEM_NUMBER

OPER_ORGANIZATION_ID

OPER_ORGANIZATION_CODE

SERIAL_NUMBER

LOT_NUMBER

QUANTITIY

CURRENT_LOCATION_CONTEXT

CURRENT_LOCATION_ID

LOCATION_ORGANIZATION_ID

LOCATION_ORGANIZATION_CODE

SUBINVENTORY_CODE

INVENTORY_LOCATOR_ID

WORK_CENTER_ID

WORK_CENTER_CODE

WORK_ORDER_ID

WORK_ORDER_OPERATION_ID

SALES_ORDER_ID

SALES_ORDER_NUMBER

SALES_ORDER_LINE_ID

SALES_ORDER_LINE_NUMBER

CUSTOMER_ID

CUSTOMER_NAME

CUSTOMER_NUMBER

SITE_CUSTOMER_ID

SITE_CUSTOMER_NAME

SITE_CUSTOMER_NUMBER

CUSTOMER_SITE_ID

CUSTOMER_SITE_NAME

CUSTOMER_SITE_NUMBER

BILL_TO_CUSTOMER_ID

BILL_TO_CUSTOMER_NAME

BILL_TO_CUSTOMER_NUMBER

BILL_TO_CUSTOMER_SITE_ID

BILL_TO_CUSTOMER_SITE_NAME

BILL_TO_CUSTOMER_SITE_NUMBER

CUSTOMER_ACCOUNT_ID

CUSTOMER_ACCOUNT_NAME

CUSTOMER_ACCOUNT_NUMBER

CUSTOMER_ACCOUNT_SITE_ID

CUSTOMER_ACCOUNT_SITE_NAME

CUSTOMER_ACCOUNT_SITE_NUMBER

INTERNAL_LOCATION_CODE

SOLD_BY_BUSINESS_UNIT_ID

BUSINESS_UNIT_NAME

Query

SQL_Statement
SELECT cab.asset_id asset_id, cab.asset_number asset_number, cab.item_id item_id, item.item_number item_number, cab.item_organization_id oper_organization_id, oper_org.organization_code oper_organization_code, cab.serial_number serial_number, cab.lot_number lot_number, cab.quantity quantitiy, cab.current_location_context current_location_context, cab.current_location_id current_location_id, cab.location_organization_id location_organization_id, loc_org.organization_code location_organization_code, cab.subinventory_code subinventory_code, cab.inventory_locator_id inventory_locator_id, cab.work_center_id work_center_id, work_center.work_center_code work_center_code, cab.work_order_id work_order_id, cab.work_order_operation_id work_order_operation_id, cab.sales_order_id sales_order_id, cab.sales_order_number sales_order_number, cab.sales_order_line_id sales_order_line_id, cab.sales_order_line_number sales_order_line_number, cab.customer_id customer_id, cust.party_name customer_name, cust.party_number customer_number, cab.customer_site_party_id site_customer_id, site_party.party_name site_customer_name, site_party.party_number site_customer_number, cab.customer_site_id customer_site_id, cust_site.party_site_name customer_site_name, cust_site.party_site_number customer_site_number, cab.customer_billing_party_id bill_to_customer_id, bill_party.party_name bill_to_customer_name, bill_party.party_number bill_to_customer_number, cab.customer_billing_party_site_id bill_to_customer_site_id, bill_site.party_site_name bill_to_customer_site_name, bill_site.party_site_number bill_to_customer_site_number, cab.customer_account_id customer_account_id, cust_acct.account_name customer_account_name, cust_acct.account_number customer_account_number, cab.customer_account_site_id customer_account_site_id, cust_acct_site_ps.party_site_name customer_account_site_name, cust_acct_site_ps.party_site_number customer_account_site_number, int_loc.location_code internal_location_code, cab.sold_by_business_unit_id sold_by_business_unit_id, sold_by_bu.bu_name business_unit_name FROM cse_assets_b cab, egp_system_items_bv item, inv_org_parameters oper_org, inv_org_parameters loc_org, wis_work_centers_b work_center, hz_parties cust, hz_parties site_party, hz_party_sites cust_site, hz_parties bill_party, hz_party_sites bill_site, hz_cust_accounts cust_acct, hz_cust_acct_sites_all cust_acct_site, hz_party_sites cust_acct_site_ps, hr_locations int_loc, fun_all_business_units_v sold_by_bu WHERE item.inventory_item_id = cab.item_id AND item.organization_id = cab.item_organization_id AND oper_org.organization_id = cab.item_organization_id AND loc_org.organization_id(+) = cab.location_organization_id AND work_center.work_center_id(+) = cab.work_center_id AND cust.party_id(+) = cab.customer_id AND site_party.party_id(+) = cab.customer_site_party_id AND cust_site.party_site_id(+) = cab.customer_site_id AND bill_party.party_id(+) = cab.customer_billing_party_id AND bill_site.party_site_id(+) = cab.customer_billing_party_site_id AND cust_acct.cust_account_id(+) = cab.customer_account_id AND cust_acct_site.cust_acct_site_id(+) = cab.customer_account_site_id AND cust_acct_site_ps.party_site_id(+) = cust_acct_site.cust_acct_site_id AND int_loc.location_id(+) = cab.current_location_id AND sold_by_bu.bu_id(+) = cab.sold_by_business_unit_id

SQL_Statement

SELECT cab.asset_id asset_id,

cab.asset_number asset_number,

cab.item_id item_id,

item.item_number item_number,

cab.item_organization_id oper_organization_id,

oper_org.organization_code oper_organization_code,

cab.serial_number serial_number,

cab.lot_number lot_number,

cab.quantity quantitiy,

cab.current_location_context current_location_context,

cab.current_location_id current_location_id,

cab.location_organization_id location_organization_id,

loc_org.organization_code location_organization_code,

cab.subinventory_code subinventory_code,

cab.inventory_locator_id inventory_locator_id,

cab.work_center_id work_center_id,

work_center.work_center_code work_center_code,

cab.work_order_id work_order_id,

cab.work_order_operation_id work_order_operation_id,

cab.sales_order_id sales_order_id,

cab.sales_order_number sales_order_number,

cab.sales_order_line_id sales_order_line_id,

cab.sales_order_line_number sales_order_line_number,

cab.customer_id customer_id,

cust.party_name customer_name,

cust.party_number customer_number,

cab.customer_site_party_id site_customer_id,

site_party.party_name site_customer_name,

site_party.party_number site_customer_number,

cab.customer_site_id customer_site_id,

cust_site.party_site_name customer_site_name,

cust_site.party_site_number customer_site_number,

cab.customer_billing_party_id bill_to_customer_id,

bill_party.party_name bill_to_customer_name,

bill_party.party_number bill_to_customer_number,

cab.customer_billing_party_site_id bill_to_customer_site_id,

bill_site.party_site_name bill_to_customer_site_name,

bill_site.party_site_number bill_to_customer_site_number,

cab.customer_account_id customer_account_id,

cust_acct.account_name customer_account_name,

cust_acct.account_number customer_account_number,

cab.customer_account_site_id customer_account_site_id,

cust_acct_site_ps.party_site_name customer_account_site_name,

cust_acct_site_ps.party_site_number customer_account_site_number,

int_loc.location_code internal_location_code,

cab.sold_by_business_unit_id sold_by_business_unit_id,

sold_by_bu.bu_name business_unit_name

FROM cse_assets_b cab,

egp_system_items_bv item,

inv_org_parameters oper_org,

inv_org_parameters loc_org,

wis_work_centers_b work_center,

hz_parties cust,

hz_parties site_party,

hz_party_sites cust_site,

hz_parties bill_party,

hz_party_sites bill_site,

hz_cust_accounts cust_acct,

hz_cust_acct_sites_all cust_acct_site,

hz_party_sites cust_acct_site_ps,

hr_locations int_loc,

fun_all_business_units_v sold_by_bu

WHERE item.inventory_item_id = cab.item_id

AND item.organization_id = cab.item_organization_id

AND oper_org.organization_id = cab.item_organization_id

AND loc_org.organization_id(+) = cab.location_organization_id

AND work_center.work_center_id(+) = cab.work_center_id

AND cust.party_id(+) = cab.customer_id

AND site_party.party_id(+) = cab.customer_site_party_id

AND cust_site.party_site_id(+) = cab.customer_site_id

AND bill_party.party_id(+) = cab.customer_billing_party_id

AND bill_site.party_site_id(+) = cab.customer_billing_party_site_id

AND cust_acct.cust_account_id(+) = cab.customer_account_id

AND cust_acct_site.cust_acct_site_id(+) = cab.customer_account_site_id

AND cust_acct_site_ps.party_site_id(+) = cust_acct_site.cust_acct_site_id

AND int_loc.location_id(+) = cab.current_location_id

AND sold_by_bu.bu_id(+) = cab.sold_by_business_unit_id