APPS.OE_UPG_SO_NEW dependencies on OE_UPGRADE_WSH_IFACE

Line 817: oe_upgrade_wsh_iface sld

813: sla.terms_id
814: from
815: so_lines_all sla,
816: so_line_attributes slattr,
817: oe_upgrade_wsh_iface sld
818: /* so_line_details sld */
819: where
820: sla.line_id = slattr.line_id (+) and
821: sla.header_id = G_header_id and

Line 5007: /* Check to see if the oe_upgrade_wsh_iface have multiple

5003: WHEN OTHERS THEN
5004: l_detail_line_id:=0;
5005: END;
5006:
5007: /* Check to see if the oe_upgrade_wsh_iface have multiple
5008: details */
5009:
5010: SELECT /*+ INDEX(oe_upgrade_wsh_iface OE_UPGRADE_WSH_IFACE_N2) */
5011: count(*)

Line 5010: SELECT /*+ INDEX(oe_upgrade_wsh_iface OE_UPGRADE_WSH_IFACE_N2) */

5006:
5007: /* Check to see if the oe_upgrade_wsh_iface have multiple
5008: details */
5009:
5010: SELECT /*+ INDEX(oe_upgrade_wsh_iface OE_UPGRADE_WSH_IFACE_N2) */
5011: count(*)
5012: INTO no_of_picking_details
5013: from oe_upgrade_wsh_iface
5014: where line_detail_id = l_detail_line_id;

Line 5013: from oe_upgrade_wsh_iface

5009:
5010: SELECT /*+ INDEX(oe_upgrade_wsh_iface OE_UPGRADE_WSH_IFACE_N2) */
5011: count(*)
5012: INTO no_of_picking_details
5013: from oe_upgrade_wsh_iface
5014: where line_detail_id = l_detail_line_id;
5015:
5016: IF no_of_picking_details > 1 THEN
5017: IF l_debug_level > 0 THEN

Line 5060: from oe_upgrade_wsh_iface

5056: EXIT WHEN included_items%notfound;
5057:
5058: SELECT count(*)
5059: INTO no_of_picking_details
5060: from oe_upgrade_wsh_iface
5061: where line_detail_id = l_ii_line_id;
5062:
5063: IF no_of_picking_details > 1 THEN
5064: IF l_debug_level > 0 THEN

Line 5112: /* Check to see if the oe_upgrade_wsh_iface have multiple

5108: multiple_details_exist := TRUE;
5109: EXIT;
5110: END IF;
5111:
5112: /* Check to see if the oe_upgrade_wsh_iface have multiple
5113: details */
5114: BEGIN
5115: SELECT line_detail_id
5116: INTO l_detail_line_id

Line 5130: from oe_upgrade_wsh_iface

5126:
5127:
5128: SELECT count(*)
5129: INTO no_of_picking_details
5130: from oe_upgrade_wsh_iface
5131: where line_detail_id = l_detail_line_id;
5132:
5133: IF no_of_picking_details > 1 THEN
5134: IF l_debug_level > 0 THEN

Line 5181: from oe_upgrade_wsh_iface

5177: EXIT WHEN included_items%notfound;
5178:
5179: SELECT count(*)
5180: INTO no_of_picking_details
5181: from oe_upgrade_wsh_iface
5182: where line_detail_id = l_ii_line_id;
5183:
5184: IF no_of_picking_details > 1 THEN
5185: IF l_debug_level > 0 THEN