APPS.INV_MOVE_ORDER_PUB dependencies on DUAL

Line 496: FROM DUAL

492: x_trolin_tbl(l_index).to_locator_id IS NOT NULL THEN
493: BEGIN
494: SELECT 'Y'
495: INTO l_result
496: FROM DUAL
497: WHERE exists (
498: SELECT secondary_locator
499: FROM mtl_secondary_locators
500: WHERE organization_id = x_trolin_tbl(l_index).organization_id

Line 512: FROM DUAL

508: ELSIF l_restrict_subinventories_code = 1 and x_trolin_tbl(l_index).to_subinventory_code is NOT NULL Then
509: BEGIN
510: SELECT 'Y'
511: INTO l_result
512: FROM DUAL
513: WHERE exists (
514: SELECT secondary_inventory
515: FROM mtl_item_sub_inventories
516: WHERE organization_id = x_trolin_tbl(l_index).organization_id

Line 731: FROM DUAL;

727: /* ELSE --} {
728: --print_debug('in insert',l_api_name);
729: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
730: INTO x_trolin_tbl(l_index).line_id
731: FROM DUAL;
732: x_trolin_tbl(l_index).status_date := SYSDATE;
733: x_trolin_tbl(l_index).creation_date := SYSDATE;
734: x_trolin_tbl(l_index).created_by := fnd_global.user_id;
735: x_trolin_tbl(l_index).last_update_date := SYSDATE;

Line 922: FROM DUAL;

918: print_debug('Creating MO Line for WDD = '||x_trolin_tbl(l_index).txn_source_line_detail_id,l_api_name);
919: End If;
920: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
921: INTO x_trolin_tbl(l_index).line_id
922: FROM DUAL;
923:
924: x_trolin_tbl(l_index).status_date := SYSDATE;
925: x_trolin_tbl(l_index).creation_date := SYSDATE;
926: x_trolin_tbl(l_index).created_by := fnd_global.user_id;