APPS.RRS_SITE_INFO dependencies on RRS_SITE_ASSET_REC

Line 2418: TYPE local_rrs_site_asset_rec is RECORD (

2414:
2415:
2416: l_site_id number;
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,

Line 2427: TYPE local_rrs_site_asset_tab IS TABLE OF local_rrs_site_asset_rec;

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:
2430:
2431:

Line 2471: x_site_asset_tab(i) := rrs_site_asset_rec(

2467: x_site_asset_tab := rrs_site_asset_tab();
2468: if l_asset_details.count > 0 then
2469: FOR i in l_asset_details.First..l_asset_details.Last LOOP
2470: x_site_asset_tab.Extend();
2471: x_site_asset_tab(i) := rrs_site_asset_rec(
2472: l_asset_details(i).ITEM_DESCRIPTION
2473: ,l_asset_details(i).ITEM
2474: ,l_asset_details(i).ITEMINSTANCE
2475: ,l_asset_details(i).SERIALNUMBER