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

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 134: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;

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;
135: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
136: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
137: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
138: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();

Line 135: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();

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;
135: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
136: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
137: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
138: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
139: idxpargen_tmp NUMBER;

Line 136: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();

132: AND delivery_detail_id = p_delivery_detail_id;
133: */
134: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;
135: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
136: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
137: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
138: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
139: idxpargen_tmp NUMBER;
140: idxgen_tmp NUMBER;

Line 137: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();

133: */
134: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;
135: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
136: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
137: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
138: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
139: idxpargen_tmp NUMBER;
140: idxgen_tmp NUMBER;
141: idx1 VARCHAR2(255);

Line 138: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();

134: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;
135: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
136: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
137: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
138: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
139: idxpargen_tmp NUMBER;
140: idxgen_tmp NUMBER;
141: idx1 VARCHAR2(255);
142: idx2 NUMBER := 1;

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 395: wsh_opsm_asn_item_genealogy.get_genealogy(

391: IF NOT get_genealogy_called.EXISTS(TO_CHAR(v_cur_itemdetails.DELIVERY_DETAIL_ID)
392: || '.' || TO_CHAR(v_cur_itemdetails.GENEALOGY_OBJECT_ID)) THEN
393: get_genealogy_called(TO_CHAR(v_cur_itemdetails.DELIVERY_DETAIL_ID)
394: || '.' || TO_CHAR(v_cur_itemdetails.GENEALOGY_OBJECT_ID)) := 1;
395: wsh_opsm_asn_item_genealogy.get_genealogy(
396: v_cur_itemdetails.GENEALOGY_OBJECT_ID ,
397: v_cur_itemdetails.DELIVERY_DETAIL_ID,
398: v_cur_itemdetails.DELIVERY_ID ,
399: v_cur_itemdetails.ORGANIZATION_ID,

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 1201: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;

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;
1202: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1203: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1204: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
1205: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();

Line 1202: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();

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;
1202: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1203: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1204: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
1205: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1206: idxpargen_tmp NUMBER;

Line 1203: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();

1199: AND delivery_detail_id = p_delivery_detail_id;
1200: */
1201: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;
1202: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1203: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1204: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
1205: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1206: idxpargen_tmp NUMBER;
1207: idxgen_tmp NUMBER;

Line 1204: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();

1200: */
1201: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;
1202: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1203: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1204: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
1205: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1206: idxpargen_tmp NUMBER;
1207: idxgen_tmp NUMBER;
1208: idx1 VARCHAR2(255);

Line 1205: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();

1201: rslt_tab_idx wsh_opsm_asn_item_genealogy.t_var_idx_num;
1202: rslt_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1203: rslt_par_tab wsh_opsm_asn_item_genealogy.tab_genealogy1;-- := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1204: rslt_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy := wsh_opsm_asn_item_genealogy.tab_genealogy();
1205: --rslt_par_tab_tmp wsh_opsm_asn_item_genealogy.tab_genealogy1 := wsh_opsm_asn_item_genealogy.tab_genealogy1();
1206: idxpargen_tmp NUMBER;
1207: idxgen_tmp NUMBER;
1208: idx1 VARCHAR2(255);
1209: idx2 NUMBER := 1;

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 1460: wsh_opsm_asn_item_genealogy.get_genealogy(

1456: IF NOT get_genealogy_called.EXISTS(TO_CHAR(v_cur_itemdetails.DELIVERY_DETAIL_ID)
1457: || '.' || TO_CHAR(v_cur_itemdetails.GENEALOGY_OBJECT_ID)) THEN
1458: get_genealogy_called(TO_CHAR(v_cur_itemdetails.DELIVERY_DETAIL_ID)
1459: || '.' || TO_CHAR(v_cur_itemdetails.GENEALOGY_OBJECT_ID)) := 1;
1460: wsh_opsm_asn_item_genealogy.get_genealogy(
1461: v_cur_itemdetails.GENEALOGY_OBJECT_ID ,
1462: v_cur_itemdetails.DELIVERY_DETAIL_ID,
1463: v_cur_itemdetails.DELIVERY_ID ,
1464: v_cur_itemdetails.ORGANIZATION_ID,

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