eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_OPSM_ASN_BE_PKG dependencies on WSH_OPSM_ASN_ITEM_GENEALOGY_V

Line 130: FROM wsh_opsm_asn_item_genealogy_v

126: CURSOR cur_itemgenealogy(p_delivery_id IN NUMBER,
127: p_delivery_detail_id IN NUMBER)
128: IS
129: SELECT *
130: FROM wsh_opsm_asn_item_genealogy_v
131: WHERE delivery_id = p_delivery_id
132: AND delivery_detail_id = p_delivery_detail_id;
133: */
134: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;

Line 145: V_CUR_ITEMGENEALOGY wsh_opsm_asn_item_genealogy_v%ROWTYPE;

141: idx1 VARCHAR2(255);
142: idx2 NUMBER := 1;
143: idxpargen VARCHAR2(255);
144: idxgen NUMBER;
145: V_CUR_ITEMGENEALOGY wsh_opsm_asn_item_genealogy_v%ROWTYPE;
146: l_start_timec VARCHAR2(200) ;
147: l_end_timec VARCHAR2(200) ;
148: l_time_diff_secs NUMBER;
149: l_get_genealogy BOOLEAN := true;

Line 634: FROM wsh_opsm_asn_item_genealogy_v

630: v_lot_number ,
631: v_serial_number ,
632: v_hierarchy_level ,
633: v_organization_id
634: FROM wsh_opsm_asn_item_genealogy_v
635: WHERE delivery_id = v_cur_itemgenealogy.delivery_id
636: AND delivery_detail_id = v_cur_itemgenealogy.delivery_detail_id
637: AND inventory_item_id = v_parent_inventory_item_id
638: AND lot_number = v_parent_lot_number

Line 1197: FROM wsh_opsm_asn_item_genealogy_v

1193: CURSOR cur_itemgenealogy(p_delivery_id IN NUMBER,
1194: p_delivery_detail_id IN NUMBER)
1195: IS
1196: SELECT *
1197: FROM wsh_opsm_asn_item_genealogy_v
1198: WHERE delivery_id = p_delivery_id
1199: AND delivery_detail_id = p_delivery_detail_id;
1200: */
1201: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;

Line 1212: V_CUR_ITEMGENEALOGY wsh_opsm_asn_item_genealogy_v%ROWTYPE;

1208: idx1 VARCHAR2(255);
1209: idx2 NUMBER := 1;
1210: idxpargen VARCHAR2(255);
1211: idxgen NUMBER;
1212: V_CUR_ITEMGENEALOGY wsh_opsm_asn_item_genealogy_v%ROWTYPE;
1213: l_start_timec VARCHAR2(200) ;
1214: l_end_timec VARCHAR2(200) ;
1215: l_time_diff_secs NUMBER;
1216: l_get_genealogy BOOLEAN := true;

Line 1699: FROM wsh_opsm_asn_item_genealogy_v

1695: v_lot_number ,
1696: v_serial_number ,
1697: v_hierarchy_level ,
1698: v_organization_id
1699: FROM wsh_opsm_asn_item_genealogy_v
1700: WHERE delivery_id = v_cur_itemgenealogy.delivery_id
1701: AND delivery_detail_id = v_cur_itemgenealogy.delivery_detail_id
1702: AND inventory_item_id = v_parent_inventory_item_id
1703: AND lot_number = v_parent_lot_number