APPS.RRS_SITE_INFO dependencies on CSI_ITEM_INSTANCES

Line 2421: ItemInstance csi_item_instances.instance_number%TYPE,

2417:
2418: TYPE local_rrs_site_asset_rec is RECORD (
2419: item_description mtl_system_items_tl.description%TYPE,
2420: Item mtl_system_items_b.segment1%TYPE,
2421: ItemInstance csi_item_instances.instance_number%TYPE,
2422: SerialNumber csi_item_instances.serial_number%TYPE,
2423: Status csi_instance_statuses.name%TYPE,
2424: Quantity csi_item_instances.quantity%TYPE,
2425: StartDate csi_item_instances.active_start_date%TYPE

Line 2422: SerialNumber csi_item_instances.serial_number%TYPE,

2418: TYPE local_rrs_site_asset_rec is RECORD (
2419: item_description mtl_system_items_tl.description%TYPE,
2420: Item mtl_system_items_b.segment1%TYPE,
2421: ItemInstance csi_item_instances.instance_number%TYPE,
2422: SerialNumber csi_item_instances.serial_number%TYPE,
2423: Status csi_instance_statuses.name%TYPE,
2424: Quantity csi_item_instances.quantity%TYPE,
2425: StartDate csi_item_instances.active_start_date%TYPE
2426: );

Line 2424: Quantity csi_item_instances.quantity%TYPE,

2420: Item mtl_system_items_b.segment1%TYPE,
2421: ItemInstance csi_item_instances.instance_number%TYPE,
2422: SerialNumber csi_item_instances.serial_number%TYPE,
2423: Status csi_instance_statuses.name%TYPE,
2424: Quantity csi_item_instances.quantity%TYPE,
2425: StartDate csi_item_instances.active_start_date%TYPE
2426: );
2427: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2428: l_asset_details local_rrs_site_asset_tab;

Line 2425: StartDate csi_item_instances.active_start_date%TYPE

2421: ItemInstance csi_item_instances.instance_number%TYPE,
2422: SerialNumber csi_item_instances.serial_number%TYPE,
2423: Status csi_instance_statuses.name%TYPE,
2424: Quantity csi_item_instances.quantity%TYPE,
2425: StartDate csi_item_instances.active_start_date%TYPE
2426: );
2427: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;
2428: l_asset_details local_rrs_site_asset_tab;
2429: