APPS.RRS_SITE_INFO dependencies on CSI_ITEM_INSTANCES

Line 2494: ItemInstance csi_item_instances.instance_number%TYPE,

2490:
2491: TYPE local_rrs_site_asset_rec is RECORD (
2492: item_description mtl_system_items_tl.description%TYPE,
2493: Item mtl_system_items_b.segment1%TYPE,
2494: ItemInstance csi_item_instances.instance_number%TYPE,
2495: SerialNumber csi_item_instances.serial_number%TYPE,
2496: Status csi_instance_statuses.name%TYPE,
2497: Quantity csi_item_instances.quantity%TYPE,
2498: StartDate csi_item_instances.active_start_date%TYPE

Line 2495: SerialNumber csi_item_instances.serial_number%TYPE,

2491: TYPE local_rrs_site_asset_rec is RECORD (
2492: item_description mtl_system_items_tl.description%TYPE,
2493: Item mtl_system_items_b.segment1%TYPE,
2494: ItemInstance csi_item_instances.instance_number%TYPE,
2495: SerialNumber csi_item_instances.serial_number%TYPE,
2496: Status csi_instance_statuses.name%TYPE,
2497: Quantity csi_item_instances.quantity%TYPE,
2498: StartDate csi_item_instances.active_start_date%TYPE
2499: );

Line 2497: Quantity csi_item_instances.quantity%TYPE,

2493: Item mtl_system_items_b.segment1%TYPE,
2494: ItemInstance csi_item_instances.instance_number%TYPE,
2495: SerialNumber csi_item_instances.serial_number%TYPE,
2496: Status csi_instance_statuses.name%TYPE,
2497: Quantity csi_item_instances.quantity%TYPE,
2498: StartDate csi_item_instances.active_start_date%TYPE
2499: );
2500: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2501: l_asset_details local_rrs_site_asset_tab;

Line 2498: StartDate csi_item_instances.active_start_date%TYPE

2494: ItemInstance csi_item_instances.instance_number%TYPE,
2495: SerialNumber csi_item_instances.serial_number%TYPE,
2496: Status csi_instance_statuses.name%TYPE,
2497: Quantity csi_item_instances.quantity%TYPE,
2498: StartDate csi_item_instances.active_start_date%TYPE
2499: );
2500: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2501: l_asset_details local_rrs_site_asset_tab;
2502: