APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on DUAL

Line 488: from dual;

484: IF ( l_serial_number IS NULL ) THEN
485: IF ( l_transaction_temp_id IS NULL ) THEN
486: select mtl_material_Transactions_s.nextval
487: into l_InvPCInRecType.transaction_temp_id
488: from dual;
489:
490: l_transaction_temp_id := l_InvPCInRecType.transaction_temp_id;
491:
492: debug('About to call wsh_integration.Set_Inv_PC_Attributes tempid='||l_transaction_temp_id, 'GET_DELIVERY_LINE_SERIAL_INFO');

Line 2197: from dual

2193: BEGIN
2194: x_return_Status := 'C';
2195: select 1
2196: into exist_unspecified
2197: from dual
2198: where exists (select 1
2199: from wsh_delivery_details_ob_grp_v wdd,
2200: wsh_delivery_assignments_v wda
2201: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 2252: FROM dual

2248: BEGIN
2249: x_return_Status := 'Y';
2250: SELECT 1
2251: INTO exist_unqualified
2252: FROM dual
2253: WHERE EXISTS (SELECT 1
2254: FROM wsh_delivery_details_ob_grp_v wdd,
2255: wsh_delivery_assignments_v wda
2256: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 2260: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'P'

2256: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2257: AND wda.delivery_id = p_delivery_id
2258: AND wdd.container_flag = 'N'
2259: AND (wdd.released_status NOT IN ( 'X', 'Y' )
2260: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'P'
2261: AND (wdd.cycle_count_quantity > 0
2262: OR wdd.shipped_quantity < wdd.requested_quantity
2263: )
2264: )

Line 2265: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'S'

2261: AND (wdd.cycle_count_quantity > 0
2262: OR wdd.shipped_quantity < wdd.requested_quantity
2263: )
2264: )
2265: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'S'
2266: AND (wdd.cycle_count_quantity2 > 0
2267: OR wdd.shipped_quantity2 < wdd.requested_quantity2
2268: )
2269: )

Line 2287: from dual

2283: l_loaded VARCHAR2(1) := 'N';
2284: BEGIN
2285: select 'Y'
2286: into l_loaded
2287: from dual
2288: where exists (select 1
2289: from wms_shipping_transaction_temp
2290: where delivery_id = p_delivery_id);
2291: x_return_Status := l_loaded;

Line 2805: from dual;

2801:
2802: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2803: select mtl_material_transactions_s.nextval
2804: into l_new_transaction_temp_id
2805: from dual;
2806: if( l_debug = 1 ) then
2807: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');
2808: end if;
2809: end if;

Line 2973: from dual;

2969:
2970: if( l_transaction_temp_id = l_new_transaction_temp_id) then
2971: select mtl_material_transactions_s.nextval
2972: into l_new_transaction_temp_id
2973: from dual;
2974: if( l_debug = 1 ) then
2975: debug('new transaction_temp_id is ' || l_new_transaction_temp_id, 'split_Delivery');
2976: end if;
2977: end if;